-
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
-
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…
-
How to assign task to multiple contacts and track for each contacts completion
Hi, I'm building a sheet of tasks where some tasks will be assigned to multiple contacts and each assignee/contact will need to acknowledge that they've reviewed/completed the task. Multiple Contacts is enabled on the "assigned to" column and the preference is to have only one column to track assignees. Looking for help on…
-
Contact List Field in the New Logical Forms
I have a grid with a Contact List Column and I have imported all of my contacts from Outlook, in the grid the field will start suggesting contacts as I type. I created a form from the grid but when I launch the form and start typing in the contact field nothing is populating from my imported contact list, what am I missing?