How can I make State1 change to Complete when Status is Complete?

When Status1 is Complete; I want State1 to be Complete otherwise stay as Past Due, Due Now, or Upcoming Maintenance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!