-
Request an Approval from Email address in specific cell
Hi! I am needing some help. I am having a team member fill out a form, that form needs to be approved by several people. However it seems that the "Request an approval" needs to be a specific person (which wont work because each form will be different users", or Send to contacts in a cell, however it seems that the…
-
Multiple Contacts in Calendar App Task Owner
Currently, the Calendar App only recognizes a contact list in the Task Owner field if the contact column is single-select. If the column is multi-select, the app returns an error when trying to enter information in this field from the "New Item" function and does not let you edit if there are already contacts in the field.…
-
Importing Emails of Users, Smartsheet Not Converting to Contact First and Last Name
Hello! Has anyone figured out a way to load a column of emails or names, any combination really, into a contact column on a sheet where the user's first and last name appears rather than just the user's email? We're working on a large list that will be a source table for numerous systems and I want to user's contact to…
-
My Smartsheet Contacts...
I can see it's not possible to import the contacts to Smartsheet using the CSV file. I exported all the employees of my company to CSV file and cut it into pieces so each has less than 1000 records. However when I try to import it to my contacts in Smartsheet - nothing happens - no error window. Can you help?
-
How do you confirm the identity of an approver in an approval request?
We discovered somewhat alarmingly that the Modified By column does not record the email address of a person making an approval but rather pulls information from the cell in the approver column. Here is the use case: An approval request email is sent to Person A, who forwards the email to Person B. Person B approves the…
-
Contacts Formula?
I have a sheet with 12K+ total tasks grouped in identical sequences of 15. I need to globally assign specific tasks in each group to specific contacts. I am aware through research that formulas cannot be used on contact columns. Is there a workaround anyone has discovered? Thanks in advance.
-
Merged: The ability to send notifications to groups rather than individuals
This discussion has been merged.
-
Merged: Adding groups to preferred contacts in "contact list coloumn"
This discussion has been merged.
-
MS Project import (XML) how to deal with Contacts/Resources
I'm stuck and I'm hoping that someone can help me out. I'm importing an MS Project XML file into SS and everything works out except for the resource to contact. The "assigned To" field is filled with comma delimited names (name only no email) and I need to find a way to convert that into contacts. I can go line by line…
-
Auto populate a contact cell but still with overwrite capabilities
Hello, I am trying to "suggest" a contact in a contact list column but can't find a way to automatically populate a cell while still having the ability to overwrite it later if that suggestion is not correct. So I've got a Program column, a Suggested column, and a Assignee column. Program is a dropdown and Suggested…
