Automation changing status on % complete isn't working
Options

ASDF123
✭✭
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!