Flag for past due and complete

Al Hammond

Hi,

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,

Al

Paul Newcome

Try something like this...

=IF(Complete@row = 1, "Green", IF([Due Date]@row < TODAY(), "Red"))

Al Hammond

That works perfectly. Thanks for the quick response. Much appreciated.

Stay safe, stay healthy,

AL

Paul Newcome

Try something like this...

=IF(Complete@row = 1, "Green", IF([Due Date]@row < TODAY(), "Red"))

Al Hammond

That works perfectly. Thanks for the quick response. Much appreciated.

Stay safe, stay healthy,

AL

Paul Newcome

Happy to help! 👍️