- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2025 01:25 PM - edited ‎Feb 21, 2025 02:27 PM
I'm new to Airtable formulas, so I would appreciate your input.
I created a formula that I absolutely KNOW was working. But suddenly the field where the calculation was says #ERROR! now although it said 100% before. I can't figure out what has changed because I didn't change the fields used in the formula.
I would appreciate your help.
The field name is Sold v Booked %
The formula is:
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2025 06:41 AM
Hey @RJeanR!
Lookups are ARRAYS, rather than single values or numbers. This above means that a formula applied to a lookup would look something like this: (1, 1)/2 for example.
Airtable cannot divide a list of numbers (1, 1) by two. It would be able to divide an actual number.
To achieve that, I would suggest using a rollup rather than a lookup. On the formula for your rollup you could use MAX(), SUM(), AVG() or whatever suits your needs the best.
Let me know if you need any further help!
For more information on rollups fields, you can check this article.
For more information on lookup fields, you can check this other article.
Mike, Consultant @ Automatic Nation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2025 06:41 AM
Hey @RJeanR!
Lookups are ARRAYS, rather than single values or numbers. This above means that a formula applied to a lookup would look something like this: (1, 1)/2 for example.
Airtable cannot divide a list of numbers (1, 1) by two. It would be able to divide an actual number.
To achieve that, I would suggest using a rollup rather than a lookup. On the formula for your rollup you could use MAX(), SUM(), AVG() or whatever suits your needs the best.
Let me know if you need any further help!
For more information on rollups fields, you can check this article.
For more information on lookup fields, you can check this other article.
Mike, Consultant @ Automatic Nation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2025 09:14 AM
Thank you, @Mike_AutomaticN, for your explanation and help. I'll give that a try and get back to you. I appreciate it!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2025 11:57 AM
@Mike_AutomaticN The Rollup with SUM worked. Thank you for your help and for the articles.
