Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

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

    Notifications when added

    ✭✭✭
    edited 11/27/24 in Smartsheet Basics

    Hi,

    I have this automation:

    image.png

    The weird thing is, the Subject of the email we get is:

    Changes to SHEETNAME: + PRIMARY COLUMN entry.

    But, it's not a change, but a new entry.

    I know I can create a custom message, but it just seems weird to me that the standard message is like this. Is it incorrect? Do I have a setting incorrect?

    Additionally, having the whole primary column entry in the notification-email subject is weird too I guess.

    Any suggestions other than custom message?

    Thanks

    Continuous Improvement Facilitator in HVAC industry || Timezone CES

    Tags:
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • ✭✭✭✭✭✭
      Answer ✓

      Hi @MPath

      - I would run a manual after changing the trigger to a specific field instead of any field because when a row is added or deletes change is occurring across the entire sheet.
      - I would also check the 'Message Includes' section and test with alternating flags.

      Hope this helps!

      ~ Yvonne

      Best Regards,

      Yvonne Smythe

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭✭
      Answer ✓

      Hi @MPath

      - I would run a manual after changing the trigger to a specific field instead of any field because when a row is added or deletes change is occurring across the entire sheet.
      - I would also check the 'Message Includes' section and test with alternating flags.

      Hope this helps!

      ~ Yvonne

      Best Regards,

      Yvonne Smythe

      · Share on FacebookShare on Twitter
    • ✭✭✭

      @Yvonne Smythe Oh yeah, wow. Now that you mention that if would also trigger when something is deleted I realise I have quite a few sheets I need to alter! Thanks.

      No sure what you meant with

      "- I would also check the 'Message Includes' section and test with alternating flags. "?

      Continuous Improvement Facilitator in HVAC industry || Timezone CES

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭✭
      edited 11/27/24

      Most welcome @MPath.

      Re: Alternating Flags: See how you would prefer your notification mail to look. Message only, message w/specific fields mentioned, message with all fields and links.

      Best Regards,

      Yvonne Smythe

      · Share on FacebookShare on Twitter
    • ✭✭✭
      Yvonne Smythe

      Ah right, yes thanks. Have done so. I ended up making a custom message, but have altered the triggerfield for it

      Continuous Improvement Facilitator in HVAC industry || Timezone CES

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭✭
      IMG_1349.jpeg

      Cheers @MPath
      Be safe, be smart!
      ~yve

      Best Regards,

      Yvonne Smythe

      · Share on FacebookShare on Twitter
    • Community Champion

      It shouldn't trigger when a row is deleted because your trigger specifies when a row is added. This is also true for a row that has data changed after being added. It shouldn't trigger a notification either.

      You shouldn't have to adjust anything to avoid false triggers on deleted rows.

      CERTIFIED SMARTSHEET PLATINUM PARTNER

      10xViz

      Would you benefit from getting my help in person?

      · Share on FacebookShare on Twitter
    • ✭✭✭
      Paul Newcome

      Well, that saves me a buttocksload of work ;)

      I have to say I never did get any notifications triggered when deleting a row and have been using SmartS for over a year now. In another decade I might be up there with Paul, skills wise ;)

      Continuous Improvement Facilitator in HVAC industry || Timezone CES

      · 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