-
Notifications when all given cells have been populated?
Hello, Community! I have a multi-user Smartsheet where junior managers must enter a date in a designated cell (date approved) once they submit their required monthly report. Once all of these reports for a given store have been received, only then can that store's Senior Manager begin developing his/her report. Currently,…
-
Feature Request: Comprehensive Notification Setting
We need the option to set our notifications to include ALL changes, not just the changes of others. Right now if you subscribe to sheet notifications, the only way to get a full list of what changed is if you don't make any changes to the sheet yourself. Boooooo. Why can't I choose? Currently, if you have notifications set…
-
Feature Request - Combine row with discussion in notifications
Could not find this in the forum. Hope it's not a reapeat. So, we use SS to track multi-room multi-year projects with 10-15 people reporting on a site per day. As each person may work on several rows that day, there will be changes to the rows and changes to the discussions. Then, when the daily report comes out and you go…
-
Mail Merge Multiple Rows of Data
The task that I am trying to accomplish, is to complete a complicated mail merge for mass email. The mail merge function in MS Word or Google Docs sends out emails based on each row in your excel data sheet. Each row equals 1 email to 1 recipient. The issue is that multiple rows of data have to be sent to 1 recipient. If I…
-
Notifications to specific employees
I have 10 employees. I have a month-end assignment sheet where employees are assigned to tasks. I would like to send out an automatic notification to the assigned employee when the task has been approved by management. Alerts - Reminders have the feature of sending the reminder to the actual assigned person, not everyone.…
-
Notify assigned to that task is now ready for their work to begin
I have a product development sheet with dependencies and what I am envisioning is that when the predecessors to a particular task are completed and the task is now ready to work on, the row is emailed to the assignee. For example, internal testing has been completed so we can now submit for certification. Email Jerry to…
-
Alert to Row owner when Task Not complete and Due Date past
I posted this as a reply to another post, but thought I'd start as a new discusssion. https://community.smartsheet.com/discussion/past-due-reporting I want to send an Alert to a Task Row Owner when the Task Due Date is past and the Status is NOT complete. If this condition is true, I got the idea from the above post to…
-
Setting an alert of Green Status
Hello everyone, I am very new to SS and would like your help on the following topic: When the Status goes to Green (only on green) to send an e-mail to a specific person. All that I am getting is everytime I change status to any color will send the e-mail. Thank you
-
Notifications - Changes to cell also notifies when cell is created
Currently I have a sheet that set set to receive data from a smartsheet form. That form puts the data at the top of my sheet. I have a checkbox that is checked by default in the form [column name: New Employee]. I also have an alert that says if column "New Employee" changes notify me right away. Now at this point I have…
-
Alert notifications when web form submitted?
Is there any way to send alert notifications ONLY when a web form is submitted? I am in a scenario where I've set myself up to be alerted right away when Anything changes, but I have two co-workers who also need to be alerted right away when a web form is submitted. Would love to have this be an actual setting as opposed…
