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,


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!