Sum Numbers by Group then use results in a formula

I am new to Airtable so forgive me if this is an easy answer. I have searched the forum and can not find the solution.

I want to sum a field with several records {days worked}, by group {name}. I have accomplished this by grouping by {name} and the result shows in the group bar. I want to use the results of this in another formula calculation, in a different table.

Thank you in advance for any help.

Steve

I would change your single select field {Name} to be a linked record field, and link it to a new table. You can then use rollup fields on the new table to get the info displayed in the summary bar.

For example, to get the number of {Days Worked}, add a rollup field to the new table. Select [Progress] as the table, and {Days Worked} as the field, then use the formula function:

SUM(values)

Hope that helps!

1 Like

@Neads_Admin, you describe stuff in a simple, and a very easy-to-understand flow. I’ve decided to read everything you have ever written or may ever write in the future. Seriously - you have a talent.

2 Likes

Wow - thank you so much! You just made my day! I just love Airtable and helping people get the most of it - thanks for the kind words :slight_smile:

@Neads_Admin, you are also #1 in my book, it worked perfectly!! :grinning::smiley::blush::upside_down_face::slightly_smiling_face:

2 Likes

See, @Steve_Allington agrees - your explanations rock!

And from NH no less (Hampton Beach native).

1 Like