Mar 28, 2020 03:21 AM
Hi. Just started exploring Airbase. I want to try using it to build monthly financial projections for my service business.
Coming from Excel, I’m used to the convention of using columns/fields for months and rows/records for categories. But most of the templates and examples I’ve seen do the opposite creating a field/column for months and then doing a variety of lookup, rollups, etc to put things together.
Is this because Airbase favours using fields for formulas? Should I just change my preferences and get used to it? Or am I missing something?
I want to build my own base from scratch, because I’ve learned from experience that it’s really difficult to understand a model you haven’t built yourself, and because it seems like a good way to learn Airbase. But I would appreciate it if anyone can point me to good examples of best practice or any other resources for this.
Thanks,
Paul
Mar 28, 2020 11:49 PM
Hi @Paul_Sturrock,
Welcome to Airtable ! :grinning_face_with_big_eyes:
You are not missing something. Airtable will allow formulas in Fields, if you use a formula in a field, it will apply to the full field (unlike excel).
Its a good idea to build your own Base. A start point for me would be to import the excel into Airtable and start from there.
BR,
Mo
Aug 30, 2022 07:25 PM
Hello everyone. I work as a web analyst at one of the Colorado banks.