I am trying to use the automation template in a work plan sheet, where when I change the project status column to "completed" the "% completed" changes to 100% on the row.
I have even tried to reverse it, and say when % completed = 100% change project status to Completed.
This seems like a very simple ask, and is a baked in template, why is this not working? My peers in the same org are all seeing the same issue.
What could we be doing wrong?
