Skip to main content
Solved

Rollup Value in a Formula Doesn't Work

  • Nov 18, 2022 3:49 PM UTC
  • 3 replies
  • 123 views

Darryl_Oliver
Forum|alt.badge.img+8

My attempts to use a value from a Rollup field in the record Name field result in a circular reference error. Is this expected behavior or a bug?

Best answer by Darryl_Oliver

Jacob at Airtable Support helped me resolve this. There was no obvious circular reference, but the issue was apparently caused by using formulas to create primary field names in the related table that referenced the primary field name in the host table. The circular reference was caused by the rollup because it was referencing the linked records; whose names were referencing the host table. Don't worry, I'm confused too. 😕😕

View original
This topic has been closed for replies.

3 replies

Kamille_Parks11
Forum|alt.badge.img+27

You haven’t provided enough detail to determine whether or not this is a bug.

What are all the relevant fields, and what are the formulas used in those fields?


Darryl_Oliver
Forum|alt.badge.img+8
  • Author
  • Inspiring
  • Nov 18, 2022 6:48 PM UTC

You haven’t provided enough detail to determine whether or not this is a bug.

What are all the relevant fields, and what are the formulas used in those fields?


Rollup Formula - Formatted as currency with no decimals.

Name Formula


Darryl_Oliver
Forum|alt.badge.img+8
  • Author
  • Inspiring
  • Answer
  • Dec 6, 2022 2:33 PM UTC

Jacob at Airtable Support helped me resolve this. There was no obvious circular reference, but the issue was apparently caused by using formulas to create primary field names in the related table that referenced the primary field name in the host table. The circular reference was caused by the rollup because it was referencing the linked records; whose names were referencing the host table. Don't worry, I'm confused too. 😕😕