Alerts

Options

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

  • Shanky Paul
    Shanky Paul ✭✭✭✭✭
    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