Workflow failed due to linked cells. Need help writing formula for Status changes.

yicauble ✭✭
edited 03/29/23 in Formulas and Functions

I have the following Smartsheet and am trying to automate Status changes based on start and end dates, but from what I've read, I can't do that since my Start Date values are linked cells.

Can someone help me write a formula for the Status column to populate either: Not Started, In Progress, Complete, Overdue based on the following logic?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!