Can automation notifications be setup based on a name within a cell?
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?
Best Answers
-
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".
-
Make sure the column you are trying to select is set as a contact type column in the sheet.
Answers
-
Are you able to provide some screenshots for context?
-
If the Purchase Approved column indicates Yes or No, I would like the person listed in the Requestor field to be sent a notification.
-
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".
-
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".
-
Make sure the column you are trying to select is set as a contact type column in the sheet.
Help Article Resources
Categories
Check out the Formula Handbook template!