Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Nested IF statement - with checkboxes

Options
Elizabeth Aird
Elizabeth Aird ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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

Comments

  • rjudenberg
    Options

    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
    Mike Wilday ✭✭✭✭✭✭
    Options

    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. 

This discussion has been closed.