Completed Tasks Past Due Date

edited 12/09/19 in Formulas and Functions

I am trying to make a column with stars that is starred when a date is filled into the completion date column past the due date.

The only problem with this is that we have a recurring maintenance sheet, and there is a formula for the Due Date column that automatically populates it based on the last completion date. So whenever a date is inputted into the Date Completed column, the Due Date Column is automatically changed based on how frequently it is to occur.

I have no idea how to work around this and keep this a recurring maintenance sheet with all of its automation intact. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!