Workflow trigger "When rows are added" not being triggered

vanessay324

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.

Paul Newcome

Is the Status field an option within the form?

vanessay324

Hi @Paul Newcome, it is not. It's a column in the sheet tied to the form.

Paul Newcome

Right. I understand it is tied to the form, but is there the option within the form to enter anything in that field?

vanessay324

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.

Paul Newcome

How much time are you giving it from the time of submission until you have determined that the workflow is not working?

vanessay324

I have submissions from last Friday to this morning that still haven't been triggered.

Paul Newcome

Do you have any other automations built into the sheet? Can you provide a screenshot of a couple of sample rows?

vanessay324

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

Paul Newcome

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?

vanessay324

That works! Not sure why the Status column wasn't. Thanks so much!

Paul Newcome

Happy to help. 👍️

Not sure why it wasn't working to begin with, but at least it is working now.