Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Monthly Community / Membership Profit Calculator - Can it be done?

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

I want to find out if I can convert this Community Profit Calculator Google Sheet into an AirTable.

is that possible?

CPCv1Sheets

In the basic version simply input

  1. Membership rate
  2. Current Membership Size
  3. Membership Growth (monthly goal)
  4. Membership Churn
  5. Expenses

You will then get a breakout of how much profit you will make per month.

The Plus version I want to be able to allow multiple Membership based revenue options (I have counted 21!)

I have other ideas on how to expand including being able to sell that individual Airtable via https://paytable.io/

A future idea includes being able to indicate how many members I want in 12 or X months in the future, then the output will divide the total by the number of months to reach goal and determine the monthly profits from there.

Thoughts?

Can it be done?

If so, how?

Thanks let me know if you need more info to answer question.

1 Reply 1
Doug_Kaufman
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes this can be done - there is a design consideration since Google sheets functions as a form in your example and Airtable is a database.

For your Airtable question - we would need to determine what the output would look like, what you want to accomplish with Airtable that is not being accomplished with Google sheets, how to organize the data, and my guess is - to use Airtable pivots.

What other questions can I answer for you