Help

Re: Switching from Google Sheets Array to Airtable

1268 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Wesley_Bascom1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

We currently use google sheets to keep track of project budgets (this is fed data from a complex set of estimating/budgeting sheets plus quickbooks. The quickbooks part is manual).

I want to be able to bring all our project budgets into one sheet.

We already use airtable to track subcontractor costs, as well as other items by project, so we have the database of projects well developed.

Does anyone have any ideas for how we might now associate this estimated vs actual cost data? We could even add an actual revenue line. I’m imaging tracking this data across projects by cost code or drilling into each cost code.

It’s important that:
-We can view it in a compact interface
-Data entry is no more difficult
-Ideally we get “snapshots” over time. (I have created a pay schedule before when tracking employee hours so the idea of advancing ‘schedules’ is something I’m familiar with)

If it’s too difficult, I’ll probably just use IMPORTRANGE in google sheets to create a summary view… womp womp.

4 Replies 4
Wesley_Bascom1
5 - Automation Enthusiast
5 - Automation Enthusiast

image
This is one google sheet

Wesley_Bascom1
5 - Automation Enthusiast
5 - Automation Enthusiast

Here’s the main database that includes projects and vendors

image
and the list of cost codes

image

Wesley_Bascom1
5 - Automation Enthusiast
5 - Automation Enthusiast

And some fun images from the interface I made in the receiving database - completely unconnected, but what really brought me back to Airtable after so many years away

image

image

image

I Heart airtable

Hey @Wesley_Bascom1,

I actually just created a Project Budget template last week that is very similar to what you’ve posted. It calculates different costs per line item. It also calculates a budget vs actual.

Though it’s difficult to know exactly what your calculations are in your spreadsheet, maybe it’s a nice start.

2022-01-12_14h08_52

If you run into some limitations while converting everything, you might be able to use our On2Air Actions app for a couple of things.

  1. Airtable can’t calculate between records like Sheets can. We do have a VLOOKUP-similar function that can help with this and also some Array functions in the app.

  2. For ‘snapshots’, we have a Field Diff Log function in the Actions app the keeps a running log of changes to a field. Plus, Actions has 60+ other helpful functions.

  3. If you want custom record views, try our Amplify app

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable