Help

If Sum formula help

Topic Labels: Formulas
1079 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Amani_AFH
4 - Data Explorer
4 - Data Explorer

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)

1 Reply 1

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