#Unparseable Error When attempting to use IF function

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!