Ronin Global
  • Home
  • Articles
    • How-To: Smartsheet Help
    • Enhancement Requests: Smartsheet
    • How To: Zapier Help
    • Business Practices
    • Posts by J. Craig Williams
  • Smartsheet
  • Simulation
  • Zapier
  • References
    • Color Codes
  • About Rōnin Global
    • About Craig
  • Home
  • / How-To: Smartsheet Help
  • /
  • Smartsheet: Stop Alerting me! The task is complete!

Smartsheet: Stop Alerting me! The task is complete!

2017-02-26How-To: Smartsheet HelpSmartsheet

UPDATE 2017-03-23: Smartsheet release yesterday (2017-03-22) may have made this work-around moo.

I hope so, but won’t know for sure until I have updated a bunch of sheets. If you find something that still requires this work-around, let me know.

Smartsheet has two types of Alerts: Notifications and Reminders.

Smartsheet Alerts

A common request is how to turn them off when their usefulness has passed, for example when action has been taken to complete a task. Notifications are triggered on changes to cells (one or more) in a row. Assuming someone or something (a formula for example) is still updating the row, causing a triggered Notification and you want this notification to stop for that specific row, here’s how to do it.

Create a new column – I called mine [AlertCheck]. It should be a Text/Number type column.

If your completion marker is a check box (like [Done]), in that column, use this formula:

=IF(NOT(Done23), Modified23 + “”, “”)

otherwise, if your completion marker is the [% Complete] column, use this formula:

=IF([% Complete]23 < 1, Modified23 + “”, “”)

Both of these examples use row 23 for illustration purposes.

If the completed marker does not indicate the task/row is complete, then the formula will show the date and time from the Modified column. This is a System column that updates when any cell’s on the row contents change.

The (+ “”) is a trick to return both date and time instead of just the date from the System column.

Set up an Alert | Notification to trigger on changes to the new column ([AlertCheck]).

When the row is marked complete, the [AlertCheck] column will be blank and one more (the last) triggered Notification will be sent.

Note that both examples are shown here, but the formulas are not set up to check either criteria (though that is an easy change).

I hope this helps add a bit to your Smartsheet environment. If you have questions about this, just let me know in the comments.

 

Write a Reply or Comment Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • JADE 5.3.0 JTOPMERET® PSA
  • I Don’t Feel Petulant …
  • Unforced Error – Smartsheet UX change
  • If I have to ask
  • Avoid etc.

Recent Comments

  • Ronin Global on Defaulting to A Date in a Smartsheet WebForm
  • Julie B on Defaulting to A Date in a Smartsheet WebForm
  • Ronin Global on JADE 5.3.0 JTOPMERET® PSA
  • Thomas Roth on JADE 5.3.0 JTOPMERET® PSA
  • Ronin Global on Smartsheet: Set up Update Requests to increase workflow velocity

Archives

  • August 2023
  • May 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • February 2018
  • November 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • July 2016
  • May 2016
  • April 2016

Categories

  • Articles
  • Business Practices
  • Enhancement Requests: Smartsheet
  • How To: Zapier Help
  • How-To: Smartsheet Help
  • Politics
  • Posts by J. Craig Williams
  • Simulation

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

@2017-2023 Ronin Global | Theme by speakinginvector