COLLECT with an OR criteria

Paul Reeves
Paul Reeves ✭✭✭✭✭
edited 02/16/23 in Formulas and Functions

I have a COLLECT statement with multiple criterias, one being and involving an OR. In the below formula I have a Discipline column where I want to bring back Reading or Literature for a particular year.

=JOIN(COLLECT({SA Grid: ELA}, {SA Grid: Go/NoGo}, ="[X]", {SA Grid: Year}, =Year@row, {SA Grid: Discipline}, OR(="Reading", ="Literature"), CHAR(10) + "==============" + CHAR(10)))

Potentially, the result for 2023 could look something like... because both Reading and Literature would be considered under the ELA discipline

paul e. reeves, CBAP

Austin, Texas

Houghton Mifflin Harcourt

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!