Flag for past due and complete
I am new to Smartsheet formulas. I am trying to initiate a red flag when an item is past the due date (‘due date’ column) and the ‘complete’ column checkbox is unchecked; and, green flag when ‘complete’ checkbox is checked; regardless of the date condition. I have tried several different formulas found online/Smartsheet; Changed the column names, row numbers etc; no success.
Thanks for your time,
Help Article Resources
Check out the Formula Handbook template!