I have created an Alert from an Automation that will always notify Team Member #1 based on a specific value changing in a cell. We also need to alert a secondary team member. The secondary team member's email ID is in a column (EMP ID) that is dynamic (different, based on other values on the row).
I am using "@{{EMP ID}}" within the body of the automation's message, where "EMP ID" is a text formatted column containing fully qualified email IDs.
I have also tried "{{EMP ID}}" when the "@" has been added to the front of email ID in the cell.
I would like the notification to be received by the secondary team member in Teams ONLY. Smartsheet for Teams is being used by everyone in the test and messaging is enabled (see below).
The functionality is sporadic at best since I have only successfully gotten it work twice after many, many tests and when it did work, the notification was received several hours after the action.
Can anyone shed any light on this?