Google Sheet Workflow with Rows Added

[filipg]

I have a simple workflow adding new deals to a Google Sheet tab in raw format. Then that tab is referenced in a second tab with formatting applied. The problem is that the references do not get updated when a new row is added by HubSpot in the first tab. What's a good way to get around this without having to manually update the references in the second tab?

[karstenkoehler · Accepted solution]

Hi @filipg,

How exactly is your second sheet referencing the data sheet? It sounds like this may not be dynamic. An quick way to solve this is with an ARRAYFORMULA: https://support.google.com/docs/answer/3093275?hl=en

For example, if your data is in column A starting from A2, you can use ARRAYFORMULA to dynamically reference the range like this: =ARRAYFORMULA(A2:A).

Best regards!

[filipg · Accepted solution]

Thanks! This works like a charm. I'm just adding steps here for those who might wonder how I did it:

1. In the second tab, delete all the existing references and formulas that you want to update automatically.

2. In the first cell of the second tab where you want the references to start, enter the ARRAYFORMULA function.

3. Inside the ARRAYFORMULA function, enter the formula or reference that you want to apply to each row. For example, if you want to reference the first column of the first tab, you can use something like: =ARRAYFORMULA('First Tab'!A:A). Replace 'First Tab' with the actual name of your first tab, and adjust the column reference as needed.

4. Press Enter to apply the ARRAYFORMULA function. It will automatically populate the references for all the rows in the second tab, based on the data in the first tab. Now, whenever a new row is added in the first tab, the references in the second tab will be automatically updated to include the new row.

[karstenkoehler · Accepted solution]

Hi @filipg,

How exactly is your second sheet referencing the data sheet? It sounds like this may not be dynamic. An quick way to solve this is with an ARRAYFORMULA: https://support.google.com/docs/answer/3093275?hl=en

For example, if your data is in column A starting from A2, you can use ARRAYFORMULA to dynamically reference the range like this: =ARRAYFORMULA(A2:A).

Best regards!