Comparison Formula

[Alexis_Graham]

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

[Zollie]

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.