Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

    Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

    How can I exclude notifications to myself when I make the changes?

    ✭✭✭
    edited 03/25/25 in Smartsheet Basics

    I've seen like questions in the SS community, but I'm not having success following the suggestion of unchecking the box "Include my changes in sheet notifications" in my Personal Settings. Please advise. Thank you.

    SS_Notifications.jpg
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • Community Champion
      Answer ✓

      Hi @tlechi , great point!

      You're right that the formula works best when it's just one contact, but here's something that might help even when multiple people are commenting.

      Since the Latest Comment column always reflects only the most recent comment — including who made it and when — the logic still holds up. Even if multiple people comment around the same time, Smartsheet processes them one at a time in the order the server receives them. So the Latest Comment will always represent the valid "last" comment, and the check to see if it's you will continue to work reliably.

      image.png

      Also worth noting: adding a comment doesn't even require saving the sheet, so the update to the Latest Comment field happens independently of other edits — meaning this method remains consistent even when multiple users are working on the same row.

      There may be edge cases, but in most typical scenarios, this method seems to work quite well.

      · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      edited 03/26/25

      Hi @tlechi

      In the demo sheet below, I added a [My Comment] checkbox column with the following formula;

      =CONTAINS(me#, [Latest Comment]@row)

      Note: me# is the text value of my contact + " - " held in a Sheet Summary field.

      https://app.smartsheet.com/b/publish?EQBCT=203b922dd01749359bc621d9d7be2287

      image.png

      Using the [My Comment] as a workflow condition, I can send an alert to a different set of contacts, including me and excluding me.

      image.png
      · Share on FacebookShare on Twitter
    • ✭✭✭

      Thank you. This works for 1 contact, but I have multiple contacts entering comments to a row that may or may not be a Lead on a project.

      · Share on FacebookShare on Twitter
    • Community Champion
      Answer ✓

      Hi @tlechi , great point!

      You're right that the formula works best when it's just one contact, but here's something that might help even when multiple people are commenting.

      Since the Latest Comment column always reflects only the most recent comment — including who made it and when — the logic still holds up. Even if multiple people comment around the same time, Smartsheet processes them one at a time in the order the server receives them. So the Latest Comment will always represent the valid "last" comment, and the check to see if it's you will continue to work reliably.

      image.png

      Also worth noting: adding a comment doesn't even require saving the sheet, so the update to the Latest Comment field happens independently of other edits — meaning this method remains consistent even when multiple users are working on the same row.

      There may be edge cases, but in most typical scenarios, this method seems to work quite well.

      · Share on FacebookShare on Twitter
    • ✭✭✭

      Thank you for your attention on this.

      · Share on FacebookShare on Twitter
    • Community Champion

      Happy to help！😁

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video