Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I would like to be able to set up a conditional notification that allows the next "assigned to" person to automatically receive a notification when the task before theirs is completed or checked. There are about 5-7 different people that would need to receive this type of notification. Does anyone know how I can easily set this up?
Thanks!
There is no clear-cut way to do this. For our process, we ended up setting up a "handoff to"contact column. We then re-enter whoever the next task belongs to in the following row. It's a very manual process, but once set up it does notify the next user as intended.
In another note, one drawback to the contact column is that you can't use formulas in it to connect to other contact columns. This would be ideal. If we could set the Handoff To column to equal the Assignee column of the next row it would allow for less manual adjustment of a spreadsheet when an assignment is updated or changed.
I suggest requesting this in the Submit Product Enhancement Request link located in the Quick Links section of the community.
