Change Cell Value Automation

I have a [Status] column and a [% Complete] column

I am trying to create a change cell value automation that sets % Complete to 100 when Status changes to "Complete"

This seems to be pretty straightforward but, I cant get it to work


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!