Help with IF OR function

MikeS ✭✭✭✭
edited 04/05/24 in Formulas and Functions

Hi there,

My goal is to place a checkmark in the column if a row is either blank or the date is greater than 7 days.

Here's the formula I am using, and as you can see it is giving me an invalid operation for the blank dates.

=IF(OR(ISBLANK([Reported Date]@row), [Reported Date]@row < TODAY(-7)), 1, 0)

I feel like I'm close... but what am I missing??

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!