Nested IF statement - with checkboxes

Elizabeth Aird

I am looking for an IF statement to check the box if true, but do not check the box if NOT true.

 

=IF([Actual Response Date]47 <= [Response Due Date]47, 1, IF((ISBLANK[Actual Response Date]47), " "))

 

I have an Actual response date, so when the date is over the due date OR is blank, I do not want the checkbox to have a checkmark. This statement works but checks if the actual date is BLANK. I cannot get it to NOT check it. HELP

rjudenberg

Is it possible that you are having the problem when Response Due Date is also blank?

If so then the Actual and the Response are = so the box gets checked

Mike Wilday

Try changing your " " to a 0. For the checkbox symbol, 1 is checked and 0 is unchecked. 

=IF([Actual Response Date]47 <= [Response Due Date]47, 1, IF((ISBLANK[Actual Response Date]47), 0))

 

That should do the trick for you if the Actual Response Date is blank.