More than one contact in the contact list drop-down

We have a column type "contact list" that we use to track sales reps for individual products. Sometimes we have a product with more than one sales rep. I created a group with both sales reps as part of the group thinking I could use the group as the contact. It isn't available in the dropdown, only individuals.

I want to setup notifications for the sales reps when changes are made to their products. If there is more than one sales rep for a product, naturally I want to notify them both.

Does anyone know a workaround for this?

Find more posts tagged with

Sales

Sheets

Contacts

Product Development

Project Management

Enhancement Request

Email Notifications

Comments

Daniel Stein

For your use case, I would recommend creating a second column that you can optionally fill with the name of the second sales rep. You can then set up notifications to go to both columns. If your products that have 2 sales reps typically have 1 person as the "primary" sales rep, then you could reflect that in the column name. (In many circumstances, it works well to have a single person designated as the primary assignee, even if there are additional people also working on the area.)

We are currently working on the ability to add multiple contacts within a single column, coming later in the year.

Best regards,

Daniel

Mike Wilday

I would recommend the same thing that Daniel suggested. Its how we are currently handling multiple contacts.

Daniel! That is really good news to hear about the multiple contacts in a single column... is there any ability to use formulas to draw a contact from another contact column into one? We'd like to be able to assign a contact from the next row into the previous one with a formula? Is that forthcoming as well?

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…