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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!