Changing State Based on Criteria.

Hi all,

I think I have some syntax incorrect in my code and hoping for some help.

Currently, I have a formula that sets the State of a task based on % Complete:

"=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))"

I also have an At Risk flag set to the following:

"=IF(AND([End Date]@row < TODAY(), NOT([% Complete]@row = 1)), 1, 0)"

I'm trying to add an additional State to 'At Risk', if the flag is checked, but I'm getting an error when I try, so I assume there is an error in my formula:

"=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete", IF[At Risk]@row = 1, "At Risk"))))"

I'm sure it's VERY close to being correct, but I'm not experienced enough to figure it out. Any help?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!