Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 04, 2020 09:46 AM
To give some background, I work at a fitness company; we treat “classes” as projects.
Looking to:
Sep 08, 2020 07:36 AM
While this should be mostly possible, formulas probably aren’t the solution. Formulas only have access to data within their own row, so they won’t be able to gather up data from other rows to create the week based totals.
Instead, you should be using the scripting block and/or hiring a JavaScript developer if you don’t feel comfortable figuring it out yourself. The script would fire via a button in the blocks menu whenever you want to calculate the totals, ask the user any necessary followup questions (which rows are we working with, for example), then print out the results however you like.