Automation changing status on % complete isn't working

ASDF123
ASDF123
edited 02/10/25 in Formulas and Functions

I'm using the automation template to change the status of a task to complete when % complete = 100, but it isn't working when I change the % complete to 100 and I need it to run when I manually type 100 in the % column. Here is how I have it set up:

Trigger: When rows are added or changed

when any field changes

run workflow: When triggered

Conditions:

Where % is equal to 100% (Note, I've tried 100 and 100%)

Change cell value

Change cell value in Status to complete.

I have tried every variation I can think of and nothing works, it will not change the status to complete when I type 100 in the % column. Any help is appreciated

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!