How do you automate a status updates in smartsheet with IF formula?
My organization would like to automate the statuses in a project plan. Could we create an IF formula to accommodate this logic?
If the start date is in the past and the percentage is 0%, put status in yellow
If the percentage is 100%, put the status in green
If the end date is past due, put the status in Red
Help Article Resources
Check out the Formula Handbook template!