# Bug - IS\_KNOWN() doesn't work in Report Formula Fields

**URL:** <https://community.hubspot.com/t/bug-is-known-doesnt-work-in-report-formula-fields/137318>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [August 1, 2025, 4:14pm UTC](https://community.hubspot.com/t/bug-is-known-doesnt-work-in-report-formula-fields/137318 "2025-08-01T16:14:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JeremyCullen](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@JeremyCullen](https://community.hubspot.com/u/JeremyCullen)\
**Post date:** [August 1, 2025, 4:14pm UTC](https://community.hubspot.com/t/bug-is-known-doesnt-work-in-report-formula-fields/137318/1 "2025-08-01T16:14:16Z")

</div>

**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.

---

<div class="post-metadata">

**Author:** ![jeszhang](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jeszhang/32/54568_2.png) [@jeszhang](https://community.hubspot.com/u/jeszhang)\
**Post date:** [August 8, 2025, 1:44am UTC](https://community.hubspot.com/t/bug-is-known-doesnt-work-in-report-formula-fields/137318/2 "2025-08-08T01:44:11Z")

</div>

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!
