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

Comparison Formula

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

To give some background, I work at a fitness company; we treat “classes” as projects.
Looking to:

  1. Count number of classes scheduled in a specific week.
  2. Count number of filmed, scheduled classes in that week
  3. Find out what the percentage is of scheduled vs. filmed and if possible, show in a block
1 Reply 1

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.