Bug - IS_KNOWN() doesn't work in Report Formula Fields

HubSpot Ideas
1

Description:
When creating Formula Fields in the Report Builder, using the IS_KNOWN() function always yields an error on the “Formula Review” step.
Error text:

“A field references a formula field or property that no longer exists. You need to update the formula or remove the field.”
Steps to reproduce:
Go to report builder > create report > “Create Formula Field” > enter “IS_KNOWN([COMPANY.hs_object_id])” as the formula and click next.

2

Hey Jeremy, doing a check internally, there does seem to be an issue with the

IS_KNOWN

function in Formula Fields currently. The error message is inaccurate and the team is aware of this. They’re working on reworking the Formula Fields editing experience for the custom report builder and fix the underlying issue for this.

In the meantime, the workaround is to replace the

IS_KNOWN

function with

!= NULL

, which should work to clear the error messaging. Hope this helps!