Using an OR in COLLECT

Andy_DAI ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello - 

I'm trying to use an OR operator in the criteria of a collect function.  This is currently returning an #INCORRECT ARGUMENT SET:


=IFERROR(INDEX(COLLECT({WAP Deposit Number}, {WAP Date}, Date147, {WAP Type}, OR("CHECK", "CREDIT"), 1), ""))

I'm trying to return the a deposit number {WAP Deposit Number} if the Date matches and the type is EITHER "Check" or "Credit"

It's probably something really dumb I'm missing... 

Any ideas?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!