-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Is there a way to use a formula to tell my contact cell to populate based on another field?
So, I have my team member names populating in the sheet with just their initials - but I want to be able to tell the sheet that if those initials are in the "team" field, then add this matching contact to the "Assigned to" field. Is there a way to do this? I can drag the names down, but just was hoping for an automation
-
Collaborator name vs email appearing in Share list
When I share a Workspace, some collaborators appear in the share list with their name only and others with email only. In both scenarios, their Contact includes first name, last name and email AND both are free collaborators. I need them to appear/be listed by name, instead of email only. I've removed and shared again to…
-
Importing from Excel to Smartsheet (Grid) using names for contacts
I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would like them to come in (during the import) as SS contacts (name, icon, email shown and can be used…
-
Dynamic View
Is there a way to use the @name feature in the comments section of dynamic view? This is a great feature in the sheets but doesn't work for whatever reason in the dynamic view.
-
Can I verify each entry in a multi-contact list exists in a different multi-contact list?
I use Dynamic View. Dynamic View, unfortunately, only allows 1 single column to be the list of users who can see data in a specific row. Smartsheet is not able to combine multi-contact lists into a single column that is recognized within Dynamic View. (I can combine multi-contact lists however, e-mail addresses listed in…
-
Contact List using DataMesh & Concatenate
Hi, I have added 2 columns to a data sheet, one for Analyst Name and one for the Analyst Manager. I have brought in the email addresses of both of these by DataMesh. I want to be able to apply a current user filter to a certain column which would enable the Analyst and their Manager to only see the rows that are applicable…
-
Group Management doesn't pull from My Smartsheet Contacts anymore
I am using the new (preview) Smartsheet Admin Center "Group Managment" interface. In the old version when I wanted to add someone to a group, the "Add Member" picker would allow me to add users from our account and from My Smartsheet Contacts. It no longer does that and the picker only looks for potential new members from…
-
Inconsistency in how contacts are displayed across sheets
Hi, I have noticed inconsistency in how same contact is displayed differently across sheets. In one sheet it is displayed as name whereas in other sheet its displayed as email id. I understand that in one sheet where its displayed as name, its picking up the name from user name in my smartsheet account. But in other sheet…
-
Calling out email address using a Contact List
Hi, I would like to include an email address in an automated email body. The only problem is that the emails are stored in a "Contact List" Column. Is there anyway to automatically grab emails out of these columns? Right now the email looks like this in the body:: Customer name: {{Customer Name}} Email: {{}}