Smartsheet Basics

Smartsheet Basics

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

Alert someone when a row is deleted

✭✭✭✭✭

Hello, I have this workflow configured. However, when a row with data is deleted from the sheet, the notification is triggered, and an email is sent, but the data from that row is not displayed within the email. Does this workflow notification allow for the data to flow into the notification so the user knows what's actually been deleted?

image.png

Best Answer

Answers

  • ✭✭✭✭✭

    Hi @mmac

    Technically, the alert is running after the row has been deleted, which means the data was already deleted by the time this workflow runs, so I believe it is not possible to include what was deleted within the email alert.

  • Community Champion
    Answer ✓

    Hi,

    I hope you're well and safe!

    It's because when the Workflow triggers, there's no data left. A workaround could be to move the row to another sheet and have it trigger from that sheet instead.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic day!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • ✭✭✭✭✭

    Thank you @Andrée Starå and @Mounika for the insight. I understand the logic, but I was hopeful that the automated alert would carry over the data that was deleted, similar to how you can review the change history of the sheet. Otherwise, for this instance, the alert just tells you something has been deleted, but no one knows through the alert what that something is.

  • Community Champion

    Happy to help!

    Yes, that would be ideal, and maybe that is something that could be developed.

    Please submit an Enhancement Request when you have a moment

    Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Trending in Smartsheet Basics