Lists, Lead Scoring & Workflows

filipg
Colaborador

Google Sheet Workflow with Rows Added

resolver

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?

0 Me gusta
2 Soluciones aceptadas
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Google Sheet Workflow with Rows Added

resolver

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!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Ver la solución en mensaje original publicado

filipg
Solución
Colaborador

Google Sheet Workflow with Rows Added

resolver

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.

Ver la solución en mensaje original publicado

2 Respuestas 2
filipg
Solución
Colaborador

Google Sheet Workflow with Rows Added

resolver

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
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Google Sheet Workflow with Rows Added

resolver

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!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.