Returning a Date Value from Another Sheet if Certain Criterias are Met

I have been working on the formula to return a date value from another worksheet if certain criterias are met.

Here is the formula i input but with a formula error of #UNPARSEABLE

=INDEX(COLLECT({Send Out Date}, {Range}, =CONTAINS("Bank Confirmation", {Range}), {Client ID1}, =CONTAINS([Client ID]@row, {Client ID1}))),1)

Any help is so appreciated !



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!