-
My Smartsheet Contacts sometime display as email, and sometimes as name??
Some of my contacts display as their email address and others will show the name. I would like them all to display the name in the sheet. Is this possible?
-
Merged: Sharing contacts in different sheets
This discussion has been merged.
-
I am looking to use an Index match to concatenate a persons roles
I have a sheet to track workers roles however, some people are listed multiple times as they have multiple roles because depending on the project their role is different. I was wondering if there was a way to use an Index(match( to either concat all of their roles in 1 formula without the use of a helper column. My current…
-
User Management - Custom Job Categories
Allow entry of custom job categories. Add new fields to capture a user's business unit and department. These fields should also be included in all user reports. This functionality would be helpful for businesses that cross charge business units and depts for licenses and usage.
-
Merged: Updating distribution list for Auto delivered reports
This discussion has been merged.
-
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 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?
