#BooleanExpected in Report only - formula works fine on sheet.

Emmy Bagshaw

Hi, I have an "if" formula in my sheet that checks a box and has been working fine for months. Today, out of nowhere, I'm getting a "BooleanExpected" error on the report that relies on this sheet - although the checkbox is still operating correctly on the sheet.

Formula:

=IF(AND(NOT(ISBLANK([Date Inspected]@row)), [Inspection Type]@row = "Check-Out"), true, false)

I've also used:

=IF(AND((NOT(ISBLANK([Date Inspected]@row))), [Inspection Type]@row = "Move-Out wResident"), 1,0)

Please my dear Smartsheet homies, help!

Paul Newcome

You may need to reach out to Support for this one.

Paul Newcome

You may need to reach out to Support for this one.

Emmy Bagshaw

https://community.smartsheet.com/discussion/comment/474298#Comment_474298

Will do. Thanks, Paul.