Rollup for patient treatment

I have built a database to record a patient’s treatment.
I have shared with him a form to introduce the pills he takes… .but I still have to add up the number of tablets he takes in a day, a week or a month….
I have tried with sum and rollup formulas … BUT I DON’T KNOW HOW TO DO IT!
Could you help me get it?
What steps should I follow…. What can you think of?
I could even share my database with some of you to help me make this column, sum, sum or rollup….


Hi @Hugo_Mongay,

Welcome to Airtable Community! :smiley:

You can do a rollup and set it to CountA, that is correct. What a rollup does is Count the number of records In a linked field.


I did it !!!

I love airtable!

So, I did it, readding

Count only specific multi-select items in one record

with your answer…

Thanks Mo!!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.