Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

If Sum formula help

Topic Labels: Formulas
473 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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