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!
An Upwork top-rated consultant here:
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:
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.
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 email@example.com