- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 08, 2020 03:53 PM
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)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 08, 2020 10:08 PM
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