Automate At Risk flag

I am very new to Smartsheet - trying to figure this out and could use some help.

I need to have my At Risk flag marked automatically if a task is due [Complete By] within three days and the [% Complete] is not 100%.

The one I am currently using is not working: =IF(AND([Complete By]@row >= TODAY(2), [% Complete]@row < 1), 1, 0)

I know this has been asked before - I have been reading them all (that's where I got that formula) and can't seem to find one that will work.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!