Can you create email notifications on several different cells in a single column

Options

Good morning,

My project team asked me to create an inventory smartsheet.

They are requesting email notifications for a single column, but for different inventory amounts on each cell.

image.png

Is this possible??

Best Answer

  • VBAGuru
    VBAGuru ✭✭✭✭✭✭
    Answer ✓

    You would just use the Conditions, when setting up that Automation to look at the Fruit Name and the Less Than columns. You could do one individual automation for each or use the decision trees for making a single automation that has all of them just separated out.

    image.png

Answers

  • VBAGuru
    VBAGuru ✭✭✭✭✭✭
    Answer ✓

    You would just use the Conditions, when setting up that Automation to look at the Fruit Name and the Less Than columns. You could do one individual automation for each or use the decision trees for making a single automation that has all of them just separated out.

    image.png

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!