Not Counting Blank cells in Checkbox formula

Mike Wilday

Try =IF(OR(ISBLANK([Delivery Date Actual]@row),ISBLANK([Delivery Date Plan]@row)),0, IF([Delivery Date Actual]@row <= [Delivery Date Plan]@row, 1, 0))

You don't need row numbers if you are using @row. 

renee.duke99201

Mike you are my HERO!!!!!

It worked! Thank you so much, I've been at this for days. lol

 

Thank you!!

Mike Wilday

Haha. You're welcome. I'm happy we could figure it out for you! Sometimes Smarthseet requires a team effort!  

renee.duke99201

lol for sure! You're the best, have a great day!  

 

Andrée Starå

Glad you got it working!

Have a fantastic day!

Mike Wilday

You too!