Comparison Formula

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

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
10 - Mercury
10 - Mercury

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.