Smartsheet Basics

Smartsheet Basics

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

Smartsheet automation

Hi Everyone,

I am trying to figure out a way to automate a sheet that I have to send the submitter a response when a comment is put in the row with their question or request. I tried adding a column that has a yes or no- response required. I was trying to set it up so that if they checked yes, then they would receive a notification that a response had been posted. I must have something wrong because I did a test with me, and I did not get a notification. Any suggestions?

Thanks in advance!

Freda

Best Answers

Answers

  • ✭✭
    Answer ✓

    @FTesseneer, I would recommend using an automation like the below. when a comment is added, it will notify the person in the cell you specify, in your case I would assume something like 'submitted by', make sure the submitter column is a 'contact list' column (in column properties).

  • ✭✭✭✭
    Answer ✓

    Thanks Laura,

    I don't see the option for Added or Changed.

    Thank you so much for your help.

    Freda

  • @FTesseneer, ah! It looks like I assumed when you said 'comments' that is was the smartsheet comment capability (near attachments in the leftmost column) rather than a unique column for comments. Would 'changes to any value' work for you? The notifications should work the same way. Or you could keep your checklist column as well. make sure you save the sheet in order for the automation to be triggered.

  • ✭✭✭✭

    I tried using any value and it still did not work. I will try again and see what happens.

    Thanks for responding!

    Freda

  • ✭✭✭✭

    So I changed my test sheet to have a feedback column, and I linked the automation to the request made. This still did not work. Do you have any suggestions?

    Freda

  • @FTesseneer, honestly, I can't really think of a reason why this wouldn't work. Maybe double check your notification settings. I found this thread and Debbie looked to have really good recommendations on places to check this:

    https://community.smartsheet.com/discussion/66939/i-am-not-receiving-any-notifications-from-smartsheet-and-in-email/p1

  • ✭✭✭✭
    Answer ✓

    Hi Laura, It is working now. I am not sure what was going on the other day, but the submitter is getting notified now. Thank you for your help.

    Freda

Trending in Smartsheet Basics