Workflow trigger "When rows are added" not being triggered
Hi,
I have a workflow set up that should be triggered when a new row is added but is not working. I am currently adding rows through a form submission but I've tried manually populating rows and neither are triggering the flow.
I've reviewed other posts in the community that mentioned to delete rows rather than clearing content to ensure subsequent rows are being identified as new rows. I deleted all rows and that didn't work either.
The only way I have been able to trigger the flow is if I go into "Run now..." and manually run the flow, but that defeats the purpose of it being automated. When I've done this, it also triggers incorrectly and changes all statuses to "Not started" rather than just the blanks.
Any help would be appreciated. Thanks in advance.
Answers
-
-
Hi @Paul Newcome, it is not. It's a column in the sheet tied to the form.
-
Right. I understand it is tied to the form, but is there the option within the form to enter anything in that field?
-
No, that's not an option in the form. The status is more for internal tracking purposes for each response that comes in through the form.
-
How much time are you giving it from the time of submission until you have determined that the workflow is not working?
-
I have submissions from last Friday to this morning that still haven't been triggered.
-
Do you have any other automations built into the sheet? Can you provide a screenshot of a couple of sample rows?
-
Here's an example where row 3 was inputted through a form submission and row 4 was manually inputted:
Alternatively, I found a comment in this older thread that is able to accomplish the same thing: https://community.smartsheet.com/discussion/39476/setting-a-default-value-in-a-sheet
-
Right. That's why I am trying to dig into it a bit more. Because it SHOULD be working.
What happens if you change the trigger to just be when a row is added when any field changes?
-
That works! Not sure why the Status column wasn't. Thanks so much!
-
Happy to help. 👍️
Not sure why it wasn't working to begin with, but at least it is working now.
