-
Merged: Updating distribution list for Auto delivered reports
This discussion has been merged.
-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Using a formula to assign multiple contacts
Good morning! I am having a difficult time using a formula to assign multiple contacts. I have the checkbox selected to allow multiple contacts, but it seems as though when it comes to a formula, the cell is only seeing it as text. Example: Cell1 - megan@test.com Cell2 - jones@test.com Formula: Cell1 + Cell2 This then just…
-
Counting each of the values in a multi-contact field
I have a primary sheet where team members are dropped into a contact column if they're working on a project. So the Contact column for any given project row might have one contact or three contacts in it. Then we have a project status column. Example... (Project Name Column | Team Contact Column | Status) Project 1 | Kate…
-
Owner report for My Smartsheet Contacts
In our opinion, Smartsheet Contacts need better oversight and controls. In cases where an owner leaves or transfers and the System Admin transfers their sheets to a new owner, the new owner inherits the shares that were made to the previous owners' contacts, however, these contacts don't show up in their My Smartsheet…
-
Solution for copying a Contact List column to another Contact List Column
Hello, I am trying to figure out a way to copy a contact from one column over to another column (both columns are Contact List) in the same sheet whenever someone selects "Yes" for a seperate column asking if the Reporter is the same as the Risk Response Owner. If someone selects yes, I would like for the person identified…
-
Corresponding with External contacts
Is there a way to correspond to an external contact in Smartsheets through the comments without sharing the sheet? We'd like to keep communications in Smartsheets, but we don't want to always share the sheet with a contact. Is this possible, or do we always have to share the entire sheet with whoever we @ in the comments?
-
How would I parse out a contact field with multiple contacts
We have multiple projects, each with their own project plan sheet. On each sheet we have the usual project plan columns, Start Date, End Date, Duration etc. We also have an Assignee (resource) column that is a multiple contact type. This works well on the project plan. However ... We have the same resource on multiple…
-
How to get all drop down values to pop up in one cell?
If I wanted Interns and IT to pop up in the highlighted area automatically, what formula/feature could I use? If there is a way to do that, is there any way I could have the attendee name pop up only if they checked off 100% Confirmed in the column on the right?
-
Address Capture
Hi There, As part of some of my Smartsheet applications I need to capture address details. Currently I'm using multiple fields but it would be great if 'Address' was a predefined option. To cater for International use it could have Name. Address lines 1-3, state/province/Zip/Postcode/ country As part of the configuration…