I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready.
This worked fine before, but recently the automation has stopped working consistently. I discovered that sometimes Smartsheet is adding an apostrophe before the value (e.g., '100%). When that happens, the workflow will not trigger unless I manually edit the cell and remove the apostrophe.
Has anyone else experienced this?
- Why is Smartsheet adding the apostrophe sometimes but not always?
- Is there a way to prevent this so that the automation will reliably trigger without manual cleanup?
