How to make auto calculations between two tables

[Paulina_Baray]

I have two tables that have information that is needed to create formulas to auto calculate gaps. For example, I have one table set up grouped by Month and Coach and has columns that are in currency format. They have revenue amounts and other count numbers. I have another table that is created to calculate the gap between the numbers in the first table and the newly entered numbers from Coach inputs in a form within that second table. So somehow I need to get the information that is sorted by Month and Coach into the second table to create formulas to calculate with the new information that will come from the form.

Thank you in advance!

[andywingrave]

Get in touch at my website.

[SergioCodes]

Hi @Paulina_Baray

An Upwork top-rated consultant here:

• 100% Job Success
• Upwork - Top Rated
• 5 Star Rates
• Expert in Airtable / Zapier / Google Apps Script

I think we can use a scripting block to calculate the results from your tables, and I may help you do that process.

Just to show you what I can do, here you have some links so you can see my work:

• Upwork Portfolio: https://www.upwork.com/fl/chechedotmx
• If you want to find complete information about my work (cover letter, how to work with me, availability, portfolio), please visit the next link

Feel free to schedule a free introduction call in the next link https://calendly.com/chechedotmx/introduction

I would be glad to talk about your project.

Best
Sergio

[Carter_W]

Hello,
Greetings!!

I’d Glad to assist you.
PM Sent, Please Check.

Very Best Regards
Carter W

[Andrew_Johnson1]

Hi Paulina,
Being an experienced Airtable consultant, I can say with great confidence that what you are wanting done is well within my area of expertise.
You can reach me on andrewjohnson56782@gmail.com
Best Wishes,
Andrew