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!
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!
@AlliAlosa, 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.
@AlliAlosa, 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.
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
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
See, @Steve_Allington agrees - your explanations rock!
And from NH no less (Hampton Beach native).
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!
Alli, great fix! I posted about this same topic elsewhere, but hoping you can help me. I used your Solve above to do generally the same thing. However, I have a filter applied to the view that I am using that only shows records that were completed from the last 45 days. Also, throughout the day, we have records getting completed that I want added to that rollup automatically. Do you know of a way to achieve this? Here is a link to my post: How to use summary of data (Avg) number in another formula
Thanks in advance!