Notification triggered from cell change, but not form submission.

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
-
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.
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
-
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.
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 :)
-
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.
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,