How to roll up Projects into a Portfolio table?

964 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I am the portfolio manager for a team of project managers. The project managers have one or more projects within Air Table and I want a portfolio that is a rollup of all the projects. How do we link their projects directly to my portfolio (table)?


1 Reply 1

Welcome to the community, Robin! :grinning_face_with_big_eyes:

The only way for this to work is for all tables to be in the same base. Airtable currently doesn’t support referencing between bases. With all tables in one base, rolling up the relevant info from each project manager’s table into a master portfolio table should be relatively easy.