Is not blank to determine to check box

Sborror

I have a Date field - if date field is not blank I want the a Complete checkbox field to be checked.

I've tried this

=IF(ISBLANK([VD MD Completion Date]57)1, 0)

Kelly Moore

Hey @Sborror

Just a minor tweak of your original formula. You are missing a comma

=IF(ISBLANK([VD MD Completion Date]@row),1, 0)

When you are building a formula I encourage you to insert your cursor into your formula to see where the formula wizard places you in the formula. I find it helps catch my inadvertent mistakes.

cheers,

Kelly