How to make a calculation return blank

I have a simple IF() calc that I thought would return blank if false, but when I go to make a color rule on if this column is blank it doesn't work. If I copy the output of this calculation is appears to be returning whitespace, but I can't use [field] is equal to {put a space in the text box} in the color rule.

=IF(AND([Status]@row = "Assigned",ISBLANK([Area Served]@row)),"Area Served" ,"")

How do I return a blank?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!