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.