Formula or Automation Help
Im looking for the best way to set up this formula/automation (whichever is best):
I have multiple columns collecting different contact names by title from a form:
I need a formula or automation, that when "Admin Reviewer" = yes, then it takes the contact in "Project Admin" and adds it to another column titled "PT Proof Reviewers", and when "APM Reviewer" = yes, then it takes the contact in "APM" and ALSO adds it to "PT Proof Reviewers", etc.
There are about 8 of these I need to build, that when the reviewer column says yes, it adds the corresponding contact from title column to the "PT Proof Reviewers"
I need the PT Proof Reviewers to be contacts, so that when I set up a proof and go to invite people to the proof, I can just select "PT Proof Reviewers" and all the contacts in that cell will be invited to the proof.
This is the formula im currently working with: If [Admin Reviewer] equals yes then add [Project Admin]contact ", " + if [APM Reviewer] equals yes then add [APM] contact", " + if [PM Reviewer] equals yes then add [Project Manager] contact ", " + if [Director Reviewer] equals yes then add [Director] contact ", " + if [Sr. Director Reviewer] equals yes then add [Sr. Director] contact ", "
I still havent finished this full formula, but once I add more than one, it no longer reports as a contact, just as individual names separated by a comma, and then when I go to my Proof and select invite "PT Proof Reviewers" that column no longer shows as an option (im assuming because there are not contacts in the list, just "text")
Is this possible, does that make sense?
Best Answer
-
Unfortunately there is no way to do this through automation or formula. You will need to leverage the API, one of the premium add-ons (Bridge, Data Shuttle, or Data Mesh), manual cell links, or some other third party app to be able to get this joined list as usable contacts.
The thread linked below goes through each of the various options for creating a joined list of contacts.
Answers
-
Unfortunately there is no way to do this through automation or formula. You will need to leverage the API, one of the premium add-ons (Bridge, Data Shuttle, or Data Mesh), manual cell links, or some other third party app to be able to get this joined list as usable contacts.
The thread linked below goes through each of the various options for creating a joined list of contacts.
-
Thanks so much! Ive figured out a temporary workaround until we can get one of those set up.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!