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.
Solved! Go to Solution.
Because the = and <> operators are magical: if the left-hand operand is blank, the result will be TRUE regardless of the right-hand operand. Hence ISBLANK() and ISNOTBLANK().
User | Count |
---|---|
16 | |
12 | |
9 | |
4 | |
2 |