Show corresponding cell based on another formula
I have a current sheet where I want to surface the next major milestone and next major milestone date. Currently there are a list of tasks and dates and a checkbox to identify that task as a "major milestone".
I have a formula written to show the next upcoming milestone date, but need to, based on the date referenced, surface the corresponding milestone description. For example, if the formula surfaces that the next major milestone is November 1, 2021, I want to also show that it is "Identify Key Stakeholders" that is occurring on November 1, 2021 (and that description is currently in the same row as the original date listing. Does that make sense?
Help Article Resources
Check out the Formula Handbook template!