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