Help with Formula to Return Value of Another Row when Certain Criteria are Met

2»

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Nope, that's good. In the [Job Post Date] column - are there any errors in the rows above the current row you're working on?

  • @Kelly Moore that was it - there is a blank row at the top of the sheet I am using as a link to go to a related sheet so it was blank. When I put a date in that cell it fixed the issue! I'll keep the date there and use shading to hide it. Thank you so much!

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Interesting. I would have expected the first date term in my formula 'ISDATE(@cell)' to have corrected that. It's why it needs to be the first criteria. If you didn't want to include a date in that 1st row you could further filter (assuming you have the auto number column 'Row ID' in your sheet) as Row ID <> 1. But your fix worked!

    Shout out if you run into any more problems

    Kelly