-
Combine two separate contact cells into one cell.
With the new update to Vlookup adding contact list functionality, would there be a way to combine two individual contact cells into one cell with both contacts using an equation/formula?
-
How do I share a dashboard with a large group of people?
I have created a dashboard that I want to share with our entire corporation. Is there a way in the share setting that I can grant view access to everyone that has a @XXXXX.com behind there email address that doesn't require me to add them individually into a group? We have over 2000 employees that this will be shared with…
-
Data Mesh and Contacts
I've been having a bit of a struggle. I have a Contacts column. If I enter an employee's email address, it auto-completes to the contact "card". However, if I use the contact column as the unique identifier between sheets for a data mesh, and the other sheet has email addresses entered via form (that do not automatically…
-
Master Contact List for use across sheets in a workspace
I have 16 grids that all use a Contact List with 23 of the same client contacts. (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into each of the 16 grids and make the same change. Is there a way to create a contact…
-
Can you alert/send an email to contacts in a cell that have been entered via a form?
I have my alert settings to Unrestricted, but even so, it seems those who fill out our form cannot be notified since they are not users of SmartSheet. I am looking for a solution other than the "Send me a copy of my responses" option. TIA! 😁
-
How do you make a name input on a form become a contact that is already a contact in Smartsheet?
I posted this on an old thread, but thought it might be easier to find as a new entry. I am trying to have a contact show up in cells based on input on a form. User fills out form with account manager name. For example, Rachel Alexander. Rachel is in my contacts. However, when the data from the form populates the sheet it…
-
Emails are not reliably going to my users
I have a sheet that connects to several dynamic views. One one of the dynamic views, the (unlicensed) user enters their network ID. The sheet then grabs information from another sheet to pull in email addresses for the user and their manager. There is automation that is then supposed to send email summaries of the…
-
Linking contacts from sheet A to sheet B
I am trying to connect contacts from Sheet A to a workflow automated message from a form in Sheet B. Is something like this possible? Sheet A is a database of people listing names, skills, locations, emails, etc. Sheet B is fed by a form, I would like new rows to trigger a workflow to send an automatic message to a subset…
-
Create multi-contact cell from a row array of individual contacts
I have a sheet as: Header: SME1; SME2; SME3; All SMEs Row 1: Bill Ross; Suzie Collins; Anne Doe; =join([SME1:SME3]@row) Each of the SME columns is a contact. I want to fill my 'All SMEs' column with a formula which makes a multi-contact with all of the contacts joined together for easier filtering. I've tried to write the…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
