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 ✭✭✭✭✭✭

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

Next Expense Date Formula
I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Program ( Men, Women), and Budget Impact (Income, Expense). For this formula I need to find and return the next expense date from…
Automation Question around running on a Date field
I'm working on doing some cleanup on a smartsheet that had some extra columns/automation that I don't believe are in use. I have a question around how an automation uses dates, so i'll give what is probably unneccesary background. :-) For example, in our smartsheet there is a date field called CST Due for Info Update -…
Row with Multiple drop down choices and creating a summary
We have a Column on our Sheet which is a drop down list however more than one can be picked? Is there a way to as a summary to look for that field so that it sums it up? Below are 2 which are in a row and chosen from the drop down When we do the summary we would like this to be counted in both the IT Operations and Infra…