Alerts

Hi there,
I want to use the trigger and alert to notify someone in the next row when the task above is complete. E.g., if the Status column is changed to Complete in row 3, I want an alert to be sent to the contact in the Assigned To column in row 4. Is that possible?
Megan
Best Answer
-
Hi,
You can use checkbox column to trigger the person assigned to in row 4. In row 4 checkbox, use the below formula:
=IF(Status3 = "Complete", true, false)
Thank you,
Answers
-
Hi,
You can use checkbox column to trigger the person assigned to in row 4. In row 4 checkbox, use the below formula:
=IF(Status3 = "Complete", true, false)
Thank you,
-
That's brilliant, thanks!
-
I would set 2 actions.... 1. record the date from the complete flag in row 3 and 2. use the date recording to trigger the notification to who's assigned to row 4.