Automate At Risk flag

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


  • Welp....I feel dumb.

    Thanks for the clarification - that worked like a charm and now I understand it better.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    No need to feel "dumb". You gotta learn somehow, and I am happy to help. 👍️

Sign In or Register to comment.