Link to First Row With a Blank Value in a Specific Field
I have two sheets, and I wish to link to a value in one sheet from a cell in another. Specifically, I want to include the value in Milestone, 2 in the 1st screenshot, as it is the first value with a blank date in Baseline Completion Date. The value would be linked to 6, 3 (Stage) in the 2nd screenshot. I tried using an, INDEX, COUNT combination, but I cannot determine the proper syntax.
Answers
-
Try this...
=INDEX(COLLECT({Other Sheet Milestone Column}, {Other Sheet Date Column}, @cell = ""), 1)
-
Thanks, Paul! That was perfect!
-
Happy to help. 👍️
-
I was also able to complete the entire string I was attempting to create, thanks to you!
="Milestone " + COUNT({Milestone} + 1) + " of " + COUNT({Milestone}) + " - " + INDEX(COLLECT({Milestone}, {Completion Date}, @cell = ""), 1)
Help Article Resources
Categories
Check out the Formula Handbook template!