Problem with condition based on whether or not column is empty

[Kirk_Masden]

I have a real column (one with data in the spreadsheet), called [DW Set aside], that may or may not have text in it. I want to have a virtual column display “None” if the cell is empty but to display the text if it has any. This formula seems to work:

if( len([DW Set aside])=0, “None”, [DW Set aside] )

However, the following did not work:

if([DW Set aside]="",“None”,[DW Set aside])

In regard to this second expression, it always shows “None”, even when the column has text. I wonder why.