Notifications - Changes to cell also notifies when cell is created

Russell Stanford

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 new data, and template setup to copy that data into. The problem is that I think the alert is notifying everyone if "New Employee" gets created instead of changing an existing cell.

 

I have a screen shot attached that shows "Oliver Queen" as the new hire that was created from the form and "Thea Queen" that was created from the form and now put into a template.

 

The problem is that it shows all of the sub information and not just the column "New Employee" that has been checked. Is there any way around this?  Is there a way to only send a notifications if the box is "checked" vs. "unchecked"?

 

Also say, I have notifications "Once a day", does it send you all changes that were made for the day or does it send you the notification as the sheet currently sits at the end of the day compared to the day before. 

Thanks

 

Shaine Greenwood

Notifications will trigger when any change is made to the column, including the "unchecked" checkbox populating in the cell when data is added on the respective row. 

 

A workaround that you can try if you're looking for conditional notifications is to place a formula, such as an IF statement, in a text/number column that returns a value when your conditions are met, e.g. =IF([Task Name]1 = "Oliver Queen", "Notify")

 

The example formula will return the word "Notify" when "Oliver Queen" is entered into Row 1 of the task name column. More info on formulas here: http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas#logic

Shaine Greenwood

Hello again Russell!

 

I wanted to mention that we're actively working on this feature. If you have ten minutes to spare, we'd love to get your participation in a usability study we're running.

 

For more information, see this annoncement:

https://community.smartsheet.com/announcement/weigh-smartsheets-next-strategic-feature