Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to create one field with formula as in Excel?

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

Hi

In Excel I can put formula in one field which will calculate Sum(all fields in the column)/Sum(all fields in another column)*100= percentage

How can I do it in Airtable for current and future records? I need just one value to gauge progress.

1 Solution

Accepted Solutions

Welcome to the community!

If you group your records, you can choose summaries to visually appear within the grouping headers themselves (or within the footer at the bottom of the page). This is an awesome and quick way to quickly see summaries for any grouping of records — without writing any formulas at all! :slightly_smiling_face:

Unfortunately, though, you can’t directly grab these summary values to use in your formulas. Unlike Excel, you can’t create formulas in Airtable that aggregate values across multiple records — UNLESS those values come from other records which are linked to your current record.

But in your case, it’s a very simple solution. You can just create the formula field that you want by making it appear for each record. Then group your records, and choose the summary that you want in the grouping header for that formula field.

See Solution in Thread

1 Reply 1

Welcome to the community!

If you group your records, you can choose summaries to visually appear within the grouping headers themselves (or within the footer at the bottom of the page). This is an awesome and quick way to quickly see summaries for any grouping of records — without writing any formulas at all! :slightly_smiling_face:

Unfortunately, though, you can’t directly grab these summary values to use in your formulas. Unlike Excel, you can’t create formulas in Airtable that aggregate values across multiple records — UNLESS those values come from other records which are linked to your current record.

But in your case, it’s a very simple solution. You can just create the formula field that you want by making it appear for each record. Then group your records, and choose the summary that you want in the grouping header for that formula field.