-
Can a Contact column populate based on selection in another cell?
I have two columns; Workstream and Workstream Leader. Their column types are Dropdown (Single Select), and Contact List respectively and each contains five available selections and are set to Restrict to list values only. I want the Workstream Leader column to populate with the contact that I know to be responsible for…
-
Unlicensed unable to receive verification email
I have an unlicensed user who inputs data into my smartsheet. He is supposed to received a confirmation email once his form submission has gone through with a copy of the data that he entered for his records. He is one of many employees who uses this form but is the only one unable to get the email. I have checked his…
-
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
-
Sharing a sheet with a user with 2 different emails
I have shared a sheet with a list of people. They are all in my contacts. Now, they are transitioning to a new email. I added their new emails to my list of contacts but when I try to share the sheet with them, their contact with the new email does not appear at all. I tried changing the name in my contact list, so the…
-
Adding fake user accounts - Contact list_assign to (within project plan)
Curious if anyone has suggestions. We want to be able to include a few place holder names within the project plan. The goal is to be able to do a find and replace the place holder names, with an actual person. We want to avoid adding these fake accounts to the user management section and not sure if another option outside…
-
Adding "fake users" to the project plan - Assigned to.. Contact List
Curious if anyone has suggestions. We want to be able to include a few place holder names within the project plan. The goal is to be able to do a find and replace the place holder names, with an actual person. We want to avoid adding these fake accounts to the user management section and not sure if another option outside…
-
Workflow notifications
I've sent emails to collaborators informing them of their access as well as sent the collaborators requests for approval via workflow. Not all of the collaborators have received emails from Smartsheet. All the collaborators have been set up in my contacts. Is there an additional feature I need to activate for all the…
-
Sequential Approvals with Missing Contacts
Hi All! I'm trying to build an automation that sends out approvals in sequence. If a contact column (1-3) is blank, it should skip to the next approver so the workflow can continue. As I understand the approval automation, it will run in sequence written, but if there's no contact assigned, then the workflow won't run or…
-
Single List for Multiple Contact Columns on Different Sheets
How do you create a single list of contacts and reference it in the drop-down on multiple sheets? We have a Client Development contact column on many sheets and updating them is a cumbersome/time consuming task. How do we create a single list and the sheet references that list? Can you do this with User Groups? Seems like…
-
Multiple Notifications/Emails for single workflow
I put together a workflow that sends an email for approval, however whenever the project is approved it email blasts the contact who made the request (sends out like 7 emails/notifications) that all say the same thing. Is there a way to only have it send one? What could be causing this?
