Automation occasionally works
I have set up automation to start an approval process every time a new line is added. That automation has worked without fail for the last 9 out of 12 months. It is the last three months it hasn't worked like it use to. Now in the last three months, if I use a form to add a new line to a smartsheet, the automation works everytime, however if I add a new line directly to the smartsheet, the automation use to work, but no longer does. Anyone have any ideas? Below is the automation to request approval from the manager. It is triggered when a row is added and the created column is equal to any value. The Created column is an auto numbered date so every new request has a date assigned. Can someone tell me why this automation works great when I used a form to add data to the smartsheet, but when I put in the data directly into the smartsheet the automation will not work.
Help Article Resources
Check out the Formula Handbook template!