-
Can I create a group with multiple people to give access to multiple sheets
Currently if I need to grant access to 10 people I am individually adding them to each sheet. Is there a way to create a group, add everyone to that group, and add this group by name to all the sheets instead?
-
Is there a way for me to add a contact to My SmartSheet Contacts list through an API call?
Hello, We have a pretty large volume of contacts that come in and out of our SmartSheet instance. We utilize My SmartSheet Contacts which allows them to pick their name from a Drop down list for task assignments. I'm looking to make the onboard/offboard process a little easier for our team. I already have a couple of API…
-
User Provisioning with AD
A couple of questions about the Active Directory integration. We are working on getting our Smartsheet integrated with Azure AD for SSO and SCIM User Provisioning. 1) We'd like to issue non-licensed accounts to everyone on our domain who isn't already issued a license - will current licensed users experience any…
-
Possibility to send contacts to Contact List from API
Hi, Right now is only possible to send contacts for specific sheets (and use them inside that sheet), so It would be really helpful if there is a way for posting contacts throw Smartsheet API to the contact list. As far as i can see on smartsheet dashboard it is only possible to send multi contacts throw UI and with a list.
-
Formula to combine Name and email to create a contact row
Hello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({name}+" "+{email}) and it did join them, but did not turn into a contact. Help please!
-
Using a formula to modify the contents of a multi-Contact cell
Hello, Here's the idea: Use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, it will SUBTRACT (or otherwise modify) that contact from the first cell. So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell 2: Contact2 Cell 3:…
-
Using Power Automate Flow to add new row
Hi Community, I am creating a power flow that creates rows in SS based on an email. Everything works fine until I want to add data in a contact list column. I have tried different formats without luck: only email only name First name, last name, email { email: emailAddress, name: name} I get the following error The value…
-
Using a formula to subtract out a Contact
Hello, Is it possible to use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, will SUBTRACT that contact from the first cell? So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell2: Contact2 Cell3: Use a formula that…
-
Populate contact cell with multiple email addresses for alerts?
I have investigated a few possibilities for this without success. Basically, I have a sheet of facilities with facility info. One of the items is what market that facility is in. So, If I want an alert to go to the entire market, I need to collect the email addresses for each facility that is in the market, then my…
-
Assigned to // Contact List
Hi all, I have an equipment tracker sheet that has an Assigned To column set as Contact List. I came to realize that regardless this sheet is not shared with them, they are able to change/edit/modify the cells of this tracker sheet. I don't want anybody to edit those cells except the ones that are already in the shared…
