-
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
-
Triggering an email when a subset of tasks are complete.
I have a parent task and 3 subtasks. When the Done checkbox is checked on the three subtasks I would like to send an email. How can I trigger this email?
-
Emailing Sheets with attachments
I have a sheet that has attachments to every line. I need to email this sheet, with the attachments to several people. When I use the email function (send of share sheet) only the spreadsheet comes through, but none of the attachments. Is there a way to do this???
-
Workflow Automation
I am sure this scenario has been discussed elsewhere. However, I was not able to find it. I am trying to create a workflow using Web Forms. When an employee fills out a request in a Web Form I would like to automatically send that Web Form (with an additional dropdown field 'Yes'/'No') to the employee's supervisor for…
-
Conditional Formatting on Web Forms
Does anyone know if there is a way to implement conditional formatting on web forms? For example, if I have a web form to populate a sheet, I want to be able to implement rules to email certain people based on a specific value selected in a drop down on the web form. I did try to figure this out using Zapier, but couldn't…
-
New notifications great, but still missing..............
The option of when I "save as new" the new sheet doesn't copy over the notifications/reminders. As I roll about 20 sheets over each month, it is time consuming to set up all of the notifications/reminders. Please add. Thanks
-
Collaboration between two client who both use SmartSheet
Looking for suggestions / best practices to make the most of SmartSheet with an important client who is ALSO a huge SmartSheet user. First step they requested is a simple file repository - will grow from there...
-
Advanced Notifications
Still loving this new feature but I am finding a couple of anomolies and I am unsure if it is something I am doing wrong. The email notification tells me that changes are highlighted in yellow, yet some are and some are not. Can anyone offer any advice? Many thanks Natalie Gorman
-
Viewing deleting rows
I've created a sheet that has 165 collaborators. They need to be able to change cell information. Occasionally the notification will say that a certain number of rows have been deleted. I need to be able to view what has been deleted to restore. The size of the sheet is currently 3,000 rows and changes are happening…
-
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.