If Cell A is NOT blank AND Cell B is Not blank


I'm having trouble with my syntax I believe. I need to determine if Cell A AND Cell B are NOT BLANK then execute a function otherwise leave Cell C blank.

The below is what I thought would work, however, I'm getting 'unpaseable'

=IF(AND(NOT(ISBLANK([Case Product Removed]@row)), (NOT(ISBLANK([Case Product Re-Stocked]@row)), [Construction Start]@row - 14)

What am I doing wrong?


Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓

    @PeggyLang Looks like you had some characters incorrect in your formula. Your second NOT statement should not have the Open Parentheses, and your AND statement should close before the True statement of your IF expression. See the adjusted formula below.

    =IF(AND(NOT(ISBLANK([Case Product Removed]@row)), NOT(ISBLANK([Case Product Re-Stocked]@row))), [Construction Start]@row - 14)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!