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
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
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

Formula Help! Adding Values in child rows based on date range
I'm trying to add the values entered in all child rows in a column, based on the date range (by quarter): =SUMIFS(CHILDREN([PT Total Hours]@row ), CHILDREN(Date@row ), ">=01/01/2025", CHILDREN(Date@row ), "<=03/31/2025") This is what the AI formula came back with, also what another external AI platform came back with.…
Index between a group of dates to return a corresponding row value
I need to add a formula with the "period end date" to have it automatically update to return the "period rate year" that it falls within - e.g., 1/31/25 falls within 4/1/24 and 6/30/25 so it returns 2024 in the yellow.
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…