Completed Tasks Past Due Date
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
Check out the Formula Handbook template!