Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Rollup Value in a Formula Doesn't Work

Topic Labels: Formulas
Solved
Jump to Solution
483 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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

See Solution in Thread

3 Replies 3

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.
Screen Shot 2022-11-18 at 12.45.48 PM

Name Formula
Screen Shot 2022-11-18 at 12.46.43 PM

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