-
Formula to populate multiple contacts into a cell based on role
I used the following Match/Index formula to populate the "Assigned To" column of my sheet based on the "Role" column. I have a look up table at the top of my sheet. =IFERROR(INDEX([Assigned To]$6:[Assigned To]$20, MATCH(Role@row, Role$6:Role$20, 0)), "Needs Role") There are many tasks on my sheet which are assigned…
-
Sending Alerts to Contacts w/o Sharing
I have a sheet with information that is not confidential yet isn't information I want to share with all vendors. The managers who can view the sheet already need to see all of the information currently in the sheet. (As the owner, I have other information in columns hidden from other's views ) I set up alerts to go to…
-
Automated Alerts and Actions - customize "From" in email?
When we have automated alerts and actions based on triggers the email displays from: Smartsheet Alerts & Actions (automation@smartsheet.com). Is it possible to customize this? When I manually send an update request the email display shows as my name via Smartsheet - this is better. Ideally for the automated alerts we'd…
-
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…
