Import data from multiple tables into a single summarised table

1

I’m working with data that comes from multiple tables, I need to be able to view this in a single table.
For example, if I have two separate tables say ‘Projects’ & "work orders’ having a start date and end date. I need to be able to look at these dates in a single table named ‘Summary table’. I have created a CODA doc with the same example.

link: https://coda.io/d/_dJwPGlaHS2i/Untitled-page_suSLpORj

1 Like
2

Do you want projects and work orders to appear in the summary table automatically? How are project and work orders rows created now?

1 Like
3

@Andrew_Farnsworth Thank you for reverting.

The data for the WO & Projects table is first exported out of Asana onto Google Sheets. The Google sheets are synced with Asana so that any changes in dates made on Asana will be automatically reflected in the Google sheet. The projects and WO on the summary sheet are entered manually and yes I need this to be done automatically.

FYI: The reason why I’m routing the data through Google sheets instead of directly importing it on to CODA because doing so will not import the custom field data.

1 Like