Can automation notifications be setup based on a name within a cell?

Tove Blake

I am wanting to setup an automation notification based on a name within a cell if the conditions of another cell indicate "Yes" or "No". Is this possible?

Tove Blake

Hi Paul, when I try this it won't let me save. I get the following message: "Please select at least one contact column". It won't let me select "Requestor".

Screenshot 2023-11-07 at 9.45.09 AM.png

Paul Newcome

Make sure the column you are trying to select is set as a contact type column in the sheet.

Paul Newcome

Are you able to provide some screenshots for context?

Tove Blake

Screenshot 2023-11-07 at 9.38.39 AM.png

If the Purchase Approved column indicates Yes or No, I would like the person listed in the Requestor field to be sent a notification.

Paul Newcome

You would set up an automation so that the trigger is when a field changes, indicate the yes/no field, then set the recipient as "Send to contacts in a cell".

Tove Blake

Hi Paul, when I try this it won't let me save. I get the following message: "Please select at least one contact column". It won't let me select "Requestor".

Screenshot 2023-11-07 at 9.45.09 AM.png

Paul Newcome

Make sure the column you are trying to select is set as a contact type column in the sheet.