I need help with an Index match or index collect formula using multiple criteria

Sania
Sania
edited 02/01/25 in Formulas and Functions

In this formula I need to add and additional criteria where MONTH(Date@row) matches in the other reference {1 Trans Date} I'm not sure if I can use MONTH{1 Trans Date} in the same way.

So far this formula is working, but I can't add the criteria if the month are the same and not receive an error.

=INDEX({1 Transactions #}, MATCH(Amount@row, {1 Trans Amount}, 0), IF(CONTAINS(LEFT(Vendor@row, 8), {1 TransDesc}), 1, 0))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!