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!
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
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.