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?

    · Share on FacebookShare on Twitter
  • Bethany Garcia
    Bethany Garcia ✭✭✭✭

    @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!

    · Share on FacebookShare on Twitter
  • 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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!