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!
