Forum Discussion
kjartank
Helper II
Helper IIProblem with conditional column
Hi. I have a problem making Conditional Columns work. Have a column with values from 0-100 and some blanks. I just want all the rows that contain a number to have text and the blanks to be em...
The cause of the problem is that you test the values if they are > 0, which won't work for nulls.
Options:
- Test if the value = null
- Test if the value <> null
- Test if the value is a number (via "Add Custom Column", not "Add Conditional Colum")
= if [Satisfaction Score] = null then null else "String" = if [Satisfaction Score] <> null then "String" else null = if [Satisfaction Score] is number then "String" else null
How exactly are you trying to do this?
kjartankHelper II
Helper III'm trying with the conditional column tool.
It just won't accept a blank as a blank.
Type null in that last box. Lowercase, no quotation marks or anything.
- kjartank
I've tried that and it just wont accept it. I get an error.
Show me the settings for the custom column again now that you've changed them.