#Unparseable Error When attempting to use IF function

Lota
Lota
edited 12/09/19 in Formulas and Functions

Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions.

For some reason I keep getting the #Unparseable error when I type out this formula.

=IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress])

I have attached a screenshot of the sheet.

Your help is greatly appreciated.

Thank you.

Smartsheet Only IF.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!