Alerts

mmburns

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

Shanky Paul

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,

Shanky Paul

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,

mmburns

That's brilliant, thanks!

dschrimpsher

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.