index/match based upon partial description

Colemcgu ✭✭✭
edited 02/09/24 in Formulas and Functions

I have scoured the community and unable to find something that works. It comes close. but not quite.

The closest I have gotten is using this formula

=IFERROR(IF(CONTAINS("bricks", {Training}), INDEX({Completion Date}, MATCH([Email]@row, {email}, 0))), "")

However it returns the date for the first item for pig1 (1/23/24) and not the date for the "bricks" class (2/3/24).

Thank you in advance for your help. This is driving me crazy! Ugh!!

Training Record

Attendance records

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!