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

  • grotto
    grotto
    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

  • Theresa Pulvere
    Theresa Pulvere ✭✭✭✭

    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.

  • kowal
    kowal Overachievers Alumni

    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.

    Tomasz Kowalski

    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!

  • grotto
    grotto
    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.