Create an alert only for form submissions (not for all added rows)

Hello,
I have a sheet that has all my project tasks in it. I just created a form that I want to use to populate requests on the same sheet. I need to create a notification alert JUST for the form submissions. I don't want to get notified every time a row is added to the sheet b/c I am constantly adding things to the sheet. It has to be specific to form entries. Is there a way to do this?
Thanks!
Brooke
Answers
-
Hi @bbene
I hope you're well and safe!
Here's a possible workaround or workarounds
- Add the Created By system column and add that as a criteria
- Add a so-called helper column and set that to a value as default and hide it in the form and use that in the Workflow
Make sense?
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@bbene Following up on Andree's advice to add the Created By column:
On your notification alert, set a Condition to only include rows where the Created By value is NOT YOUR login email.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you Andrée and Jeff! I will give it a try. Have a great weekend
-
Excellent!
Happy to help!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.