Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

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

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

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