Trying to put multiple questions into one automation

Sun

Sun ✭✭

05/05/23 in Formulas and Functions

Hi I have about 70 questions that I need to put in an automation to send an email. If it is lower than 40 or greater than 100 I'd like to have an email sent. What is the easiest way to accomplish this?

0 ·

Answers

Paul Newcome Community Champion

05/05/23

Try the "is not between" condition:

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

IF and BLANK nesting formulas
I am trying to use an IF statement in the approved column that says "If status is requested, return PIPELINE, all other statuses return APPROVE, unless it's blank then leave the cell blank". Everything I try returns #UNPARSEABLE. I had it working but someone messed with my sheet and now I can't get it back! Help :)
Formula Help
I currently have a formula to Join and Collect Date from multiple rows in Smartsheet but it is displaying the data multiple times in the single cell, I need the formula to only show each unique ID once but can't seem to get the results to work. Every time, I adjust the formula below, to try and incorporate a new function…
Index Match formula not working properly
I'm trying to use an Index Match formula to pull data from another sheet based on matching an order number (T Scan column). For some reason it works perfectly when the order number is 8 characters. Any order number less than 8 characters returns #NO MATCH. I even tried adding additional characters to one on this sheet as…