INDEX, COLLECT, CONTAINS Formula help

Beth C
Beth C ✭✭
edited 02/16/24 in Formulas and Functions

Hi!

I have a formula that is working the way I want...

=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row), 1), "")

But when I add another condition, I get #INCORRECT ARGUMENT SET. This is the formula:

=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row, {LFH Location}, CONTAINS("Home", @cell)), 1), "")

Any ideas on what may be the problem?

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!