Notification triggered from cell change, but not form submission.

image.png

Hello Everyone,

I need to send a notification to the user when the "Key Contract" cell changes from "yes" to "no" and from "no" to "yes". However, if a new row is added through a form, I only need to send a notification if the key contract is "yes".

I have changed the trigger from " when rows are added or changed" to only " when rows are changed", however the pictured workflow still sends a notification on form submittion.

Best Answer

  • Smertle_7
    Smertle_7 ✭✭
    Answer ✓

    Found the answer.

    Kowai, you are correct to say we need two workflows, one for the change in cell and another for only adding a new cell. This is the solution that I went forward with.

    I reached out to smartsheet and recieved this email.

    Smartsheet.png

    To explain this message: The workflow for notifying changes in cells has a bug. However there is still a way for the automation to perform your intended behavior. Simply, add an additional condition block where "ATTRIBUTE" is blank.

    Thanks everyone,

Answers

  • kowal
    kowal Overachievers Alumni

    hi @Smertle_7,

    why do not you create two workflows one for the change of the cell and another for only adding new cell?

    I think it would resolve your problem.

    Tomasz Kowalski

    Experienced IT PM and the Real Smartsheet Enthusiast.

    Is there anything else we can help you with? - book your time.

    MASA Consult - Your Aligned Smartsheet Gold Partner

    Find us on LinkedIn & Check our Smartsheet Solutions!

    Tag my name: @kowal if you want me to respond :)

  • Smertle_7
    Smertle_7 ✭✭
    Answer ✓

    Found the answer.

    Kowai, you are correct to say we need two workflows, one for the change in cell and another for only adding a new cell. This is the solution that I went forward with.

    I reached out to smartsheet and recieved this email.

    Smartsheet.png

    To explain this message: The workflow for notifying changes in cells has a bug. However there is still a way for the automation to perform your intended behavior. Simply, add an additional condition block where "ATTRIBUTE" is blank.

    Thanks everyone,