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.
Hi guys,
Is there a way to automatically 'alert' someone if they are 'assigned to' a task using a contact list column?
Would love to hear a workaround if you have found one.
Cheers
Amye,
Do you mean sg like this?
https://community.smartsheet.com/discussion/instant-notification-whenever-someone-assigned
There's a cool work-around from Craig.
Thanks Atus,
Yes. I tried it but can't get the 'if' function to work... still learning functions... and how they 'talk'. Will keep trying.
Do you have problems with this part: "Add formula to check the box if the column matches the Assigned To."?
it can be something like this: =IF([Assigned to]1 = "Atus Bartal", 1, 0) in a checkbox column named Atus. Then create as many checkbox columns as many people you have in the team (OK, it's nonsense if you have more than 8-10).
The second step is to set the Notifications for each person if their column changes.
I hope it works for you.
Atus
