-
Auto Update Request based on email contained in a specific column
I have a sheet of 30 rows and would like to send daily email Update Requests based on an email in one of the columns. These people are not in my contact list. Is there a way to 'bulk' issue this command for all 30 plus rows or do I have to issue 30 commands. Hope this makes sense. John
-
How to start building project roll-up with 110 dropdown names to pick also
Where to start, project roll-up, don't want a done of linked cells if can avoid it. Need it simple for user interface. Today using Excel just type it in, pick the color for the cell. The color means something based on a key. There is high-level corrdination of the overall program, then high-level for a project, then…
-
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.
-
Problems importing contacts
I have been unable to import a csv contact file into contacts having followed the instructions on Smartsheet. The system selects the file ok but when I hit 'continue' I receive an error message 'No CSV (.csv) contacts found? I have double checked the csv file and there don't seem to be any problems with it - please helps,…
-
Web Forms and Contacts
PLEASE develop a way for web forms to recognize contacts when you want to include contact names in the rows that are added to a Smartsheet! It just makes so much sense and would be so helpful! Right now, we're left to enter in the webform data, then go back into the sheet and re-type the contact person's name so that it…
-
Google Contacts (G Suite) integration not working
I've added Smartsheet to my G Suite domain but I've not been able to get contacts to automatically populate when attempting to assign people to a task. When signing in to Smartsheet I do so using my Google credentials. It feels like I've failed to authorize some setting. Or maybe there are some limitations to the number of…
-
Export List of People a Sheet is Shared With?
Is there a way to export a list from a sheet that shows the user's security level? And if so, can this list be imported to a new sheet so that each team member does not have to be added manually to the new one? This is not necessarily for a template that is used repeatedly. It is a group of about 150 people, various…
-
Contacts
I am using smartsheet to manage insurance claims. We are independent adjusters who go out and inspect a property for damage, then we write a report and submit to the insurance company. I am using one row each for individual's claim data. When the report is approved by the insurance company, I am supposed to email a copy of…
-
Row Specific Notifications
I was wondering whether the capability exists to create notifications specifically sent to a person listed in a "Contact List" field of a particular row, a la Reminders? One of our departments has a tracking sheet set up for queries, and I would like for my team memebers to automatically recieve notification when their…
-
Send an email to a contact from the sheet?
I'm building a sheet that contains various users in different roles on different teams. I'd like to email the users listed in a column when a change is made to a record. ex. I capture a program manager name in column D and when a change is made to any columns in the row, I want to email the admin (easy, set up an alert for…
