How to write a formula that automatically updates a specific cell
@Paul Newcome Is a formula possible to achieve the following automation? I am trying to set up a workflow that when a due date+1day is reached and the status isn't complete that a cell update is triggered to update the symbol in the heath column to the red stop sign from the green.
Update the Health column to either a red, yellow, green, or gray circle if:
- Status is future date= gray
- Status is complete= green
- Status is 'in progress' and the due data is in the future= green
- The due date is passed but the completed date is blank OR the status is In process and it is past the due date= Red
Thank you so much for your help!
Help Article Resources
Check out the Formula Handbook template!