Index, Collect, with Contains

I have tried this multiple ways and it's still not working. Any ideas would be greatly appreciated.

Source data:

Destination sheet:

Into the Destination sheet, I want to pull the "Task Start Date" where the Client Name and Customer Name match and where the Source "Task Description" includes "Nursing". The source sheet may contain multiple rows that meet that criteria and I just need the first occurrence.

Thank you in advance!

Jennifer

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!