Sep 28, 2022 08:16 AM
I have a field in my table that is a linked record from another table. In this field are various records all consisting of just numbers, I would like to know if it is possible for me to add up these records and output them to one field in an hour format.
To clear up, this is a base in which tutors submit a form on a student they just tutored. I need the tutoring hours to add up for me to know overall how many hours of tutoring they have received.
Sep 28, 2022 09:33 AM
Sep 28, 2022 09:58 AM
This worked great! Now, how about switching up the rules a bit, only add if they match a certain condition? Now it adds their total tutoring hours, but now I need to see if I can add only based on what subject they got tutored in. I have a drop-down select on a field, they can pick between 5 different subjects. I want to see how much tutoring they have PER subject.
So let’s say they have 30 hours, but of those 30 hours, 15 are Math, 3 are Reading and 12 are Social Studies. How can I differentiate them and add them up, because they obviously received 1 or 2 at a time.
Sep 28, 2022 10:06 AM
Welcome to the Airtable community!
You would need five different conditional rollup fields, one each for each of the different subjects. For each rollup, set the condition to only rollup records for that subject.
Sep 28, 2022 10:26 AM
What would the formula for that look like? The field names are Subject and Hours.
So how would I add that variable to the SUM formula within the rollup if the name of the field is Subject?
Sep 28, 2022 10:28 AM