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

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!