-
Multiple approvals process
I'm creating tracking for a change process through various departments. What I need after project submission into Smartsheet is: Team 1 - intake, review, notes and approval (either approved - no comments, approved with comments, or hold - with comments) Teams 2-15 - same as above No one team's approval is subject to any…
-
Automation for When Contact Not Associated Properly
I have a sheet in which data is pasted (or imported) from another source. One column (Requester) has been set up using the Contact list column type, as we have automations based on the status in another column changing or a row comment. The team entering the data pastes the data, then manually changes the Requester field…
-
Global contact list
Our company has many logins to use smartsheet, but we want to have the same contact list when adding names to a contact field on smartsheet. For example, when I add a contact to a contact field on a sheet, I can select from a list of contacts that only I have added (see image). If another staff member goes to that sheet,…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
ISCONTACT function
Looking for the ability to create a nested if statement that evaluates certain criteria, however, because some of the criteria is a contact, there isn't currently a way to define a contact in Smartsheet apart from text. It would be great if we had a function that evaluates a cell as a contact.
-
Can I create a contact group of non-Smartsheet users for a distro list?
Hi, I'm looking to set up a contact group for an event sign-up sheet, but the audience is mostly non-Smartsheet account/license holders. I'm working on bulk uploading the list as a .csv file and developing the group now, but I'm wondering if everyone on the list will require a license to be able to access it and enter…
-
Assigning Contact Based on data in another sheet
Here's the rough scenario. I have 500 students who are divided up among 20+ teachers. When I choose a student in one column, I want to auto-assign their teacher in another column. I do this in Google Sheets with a formula, but wasn't sure how to go about it here. Let me know if you need more clarification. Thoughts? Gillian
-
How can a contact field by aggregated to show a count?
I have a list of projects and each project has an individual as a contact. An individual could be listed for multiple projects. I'd like to chart to reflect how many projects each individual is responsible for. The trouble I'm encountering is that the report doesn't allow me to summarize on the contact list field and the…
-
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…