Skip to main content

I am trying to transfer my google sheets formula to airtable and I’m not sure how to do it.


I have a form where people enter data.


I want to create a possibility for me to look through that data from a certain date range and give me the sum. Here is the google formula, please let me know if you can help me transfer that to Airtable.


Time log is a “sheet” or tab or page (whatever you want to call it) in my document


=SUMIFS(‘time log’!E:E,‘time log’!B:B,C4,‘time log’!C:C,">="&A4,‘time log’!C:C,"<="&B4)

Hi @Amani_AFH,


Welcome to Airtable Community! :grinning_face_with_big_eyes:


Airtable has a different setup, in order to do that you need to link the records to another table, then use a Rollup field to sum the records in that new table.


Or you can use the Script Block.


BR,

Mo

Reply


Terms & Conditions