Complex Formula to return latest date a specific value was used and return a value from a dif column
Alright, I've got a pretty complex formula (at least for me..) that I've been banging my head against and could definitely use a little help from the awesome community!
Here's what I am trying to do (see screenshots for reference).
I'm attempting to create a formula in the "Latest Backlink Live" Column. I would like the formula to look at the "root domain@row" in screenshot 1 and then use that value, to search "Backlink" column in Screenshot 2. to return the array of rows that contain that root domain from screenshot 1.
The next step with this array is to segment the exact row I'm looking for. I'd only like it to count the row if column status = live & then bring back the one that has the latest date.
Thank you for any help solving this one! -Devon
Help Article Resources
Check out the Formula Handbook template!