Using <=/>= in an Alert

Sara C
edited 12/09/19 in Smartsheet Basics

Hi - 

I am trying to set up an Alert for when a column gets to greater than or equal to .75. When specifying a change, I can only select existing values. When I have typed ">= .75" I have not gotten any updates when that change is met. It makes me believe that typing in "<=" is not valid. 

I have looked through the community posts and it looks like you used to be able to choose a "greater or equal to' option when setting up an alert, not sure what happened to it. Maybe when the layout of the Alert set up changed it made it not as obvious anymore?

Thanks for your help!

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You can set it by adding a condition. See screenshot below. Just click on the + below the criteria box.

    Capture.PNG

    thinkspi.com

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Paul,

    I knew that, but somehow it escaped me at the time. surprise

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi Sara, 

    I think this is actually possible. Check out my screenshot to see the results (right-click to open in a new tab and enlarge it). 

    1. Set up a new action for when a row is added or updated. 
    2. Set the action to look at any changes to the percentage column. 
    3. Add a condition, Only when Percentage is greater or equal to...
    4. add .75 as the value
    5. determine who the alert should go to. 

    Let me know if that works. 

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Whoops forgot the screenshot! 

    2019-01-08_09-45-44.gif

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    And it looks like Paul beat me. laugh

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Sara, if you don't set the change specifically to the percentage field, in the first box of the alert, you will get an alert anytime, anything on the row changes, not just when the percentage changes. just something to consider as you're setting it up. 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    No worries. I was on a 3 day tirade when they first changed the Alerts and Actions format. Then a coworker asked "What if you click on that little plus thingy there?" Hahahahahahaha laugh

    thinkspi.com

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Haha. Usually I open up a thread to answer and see that either you or Andree has already answered. (Craig has been rather quiet lately. Hmm...). This time it was my turn. Hahaha

    thinkspi.com