Unparseable Error!
Does anyone know why this formula is coming up as unparseable?
=IF([Impact Assessment]@row = "NA", NA)
Best Answer
-
try this - make sure your "true" value is text in quotes, and add a "false" value of a blank row using double quotes:
=IF([Impact Assessment]@row = "NA", "NA","")
Answers
-
try this - make sure your "true" value is text in quotes, and add a "false" value of a blank row using double quotes:
=IF([Impact Assessment]@row = "NA", "NA","")
-
It worked! Thank you so much!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!