Formula ISNOTBLANK with multiple cells


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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!