How to flag AT Risk task

Options
Djay
Djay
edited 12/09/19 in Smartsheet Basics

I have Planned FInish Date (Date field), and Actual Finish (Date field) and  % Complete field, I want to flag the task if it's past due and incomplete.

 

currently I tried :=IF(OR([Plan Finish]@row - DATEONLY([Actual Finish]@row) < 0, [% Complete]@row < 0), 1)

 

but not working as intended.

 

Thanks

DJ

Comments