How to use formula to capture and match item from a range of data?

Vivien Chong
Vivien Chong โœญโœญโœญโœญโœญโœญ
edited 11/11/22 in Formulas and Functions
Screenshot 2022-11-11 at 3.23.04 PM.png

I have this sheet that will record the various documents checklist for each client. The Client ID may repeat.

Whenever Doc 2 is completed, a staff will record the date in the Send Out Date.

We have Sheet 2 that we would like to pull this Send Out Date when the range between Task 1 - Task 4 display "Doc 2", and the client ID matches.

Screenshot 2022-11-11 at 3.25.43 PM.png

Is there anyway we can write a formula to capture the send out date from Sheet 1, when the following criteria matches:

1) Client ID

2) Task 1 - Task 4 display "Doc 2"

Appreciate assistance in working out this formula.

Vivien Chong

Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

Connect with us: 57network.com

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!