Formula ISNOTBLANK with multiple cells

Connie Cochran

Hi I'm trying to write a formula that says if cell A is not blank and cell B is not blank but cell C is blank say false but I am getting an error. Help?

=IF(ISNOTBLANK([Total number of cases (100) of 10 kits]@row),(ISNOTBLANK([Shipped Date]@row),ISBLANK([Received Date]@row)=false)

Paul Newcome

Try this:

=IF(AND(NOT(ISBLANK([Total number of cases (100) of 10 kits]@row)), NOT(ISBLANK([Shipped Date]@row)), ISBLANK([Received Date]@row)), "false")

Paul Newcome

There is no "ISNOTBLANK" function in Smartsheet. You have to combine the NOT and ISBLANK function.

NOT(ISBLANK([Column name]@row))

Connie Cochran

Thank you for your help. So I redid it and still getting an error??

=IF(NOT(ISBLANK([Total number of cases (100) of 10 kits]@row)), (NOT(ISBLANK([Shipped Date]@row)), ISBLANK([Received Date]@row)=false)))

Paul Newcome

Try this:

=IF(AND(NOT(ISBLANK([Total number of cases (100) of 10 kits]@row)), NOT(ISBLANK([Shipped Date]@row)), ISBLANK([Received Date]@row)), "false")

Connie Cochran

PERFECT! Is there a way to make it check a box vs return false??

Connie Cochran

Nevermind, I figured it out. THANK YOU SO MUCH!!!!! I really appreciate the help

Paul Newcome

Happy to help. 👍️