Workflow not triggered when a new row is added.
Hello - I created a workflow, to ensure that anytime a new row is added, it will by default, check the "Show on Report" field, which is unchecked by default currently.
-The trigger is "When a new row is added" and Run "When Triggered"
However, I have added a number of rows as a test over the past hour and it hasn't checked the box one time.
I was hoping that someone would know what I'm doing wrong.
Best Answer
-
Thanks for the help. I noticed that I had another workflow that sets the % completed under these similar conditions. I could see that it updated the cell, because there was a blue highlight when the automation ran. Interesting it can take about 30 seconds to update.
Anyway, to make it work, I changed it to: "When rows are added or changed…" not just rows are added. I also used the created by field as you suggested, which is system generated.
Answers
-
I'm afraid I'm getting a similar result. It worked when I ran it or tested the workflow. It doesn't work automatically when I added a row. Odd, seems it should work, sorry no help.
-
Hello @grotto,
I would try with different approach. When you trigger the workflow use different column than "Show on report" like "Line ID" has any value.
Then in conditions you set up that if "Show on Report" is Unchecked you check it.
Let me know if it helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Thanks for the help. I noticed that I had another workflow that sets the % completed under these similar conditions. I could see that it updated the cell, because there was a blue highlight when the automation ran. Interesting it can take about 30 seconds to update.
Anyway, to make it work, I changed it to: "When rows are added or changed…" not just rows are added. I also used the created by field as you suggested, which is system generated.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives