Pull a value from sheet with either multiple IFs or IF combined with V look up

Ryan Rooke
✭✭✭
Hi - based on 2 different criteria I am looking to pull a date from a separate sheet. I have these attempts but had no luck -
Any help suggestions much appreciated.
Ryan
Tags:
Best Answer
-
You are most likely going to want an INDEX/COLLECT.
=INDEX(COLLECT({Date Column}, {Task Name Column}, @cell = Project@row, {Helper Column}, @cell = [helper parent]@row), 1)
Answers
-
You are most likely going to want an INDEX/COLLECT.
=INDEX(COLLECT({Date Column}, {Task Name Column}, @cell = Project@row, {Helper Column}, @cell = [helper parent]@row), 1)
-
Thanks for that Paul. Worked perfectly. Never used this formula before but certainly will going forward.
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!