Formula to Overwrite Conditional Formatting or Help to Figure Out Another Solution



When a date is entered in Date Assigned to ID, I have a formula that populates the Analysis Due Date for 30 days after (=[Date Assigned to ID]1 + 30). I also have conditional formatting on the Analysis Due Date that changes colors based on days out from 30 days.

What I need to do is change Analysis Due Date back to white when the TRB Authorization (row 14) has a date in Date Completed.

Thank you :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!