Skip to main content

Dynamic Google Sheets Formulas

  • December 1, 2020
  • 3 replies
  • 1390 views

GetUWired
Forum|alt.badge.img+12

Figured this workaround out today but have been trying to figure this out for a bit so I thought I would share in case anyone else needed it! This is to create dynamic formulas that will calculate data as rows come in to google sheets. First use the create row step to create the row without the formula fields or with formula fields that are not dynamic. 

Immediately after this step, add another step to Update a Row. Use the custom tab to insert the row that was created in the previous step for the row to be updated then when you type in your formulas you can insert that same row Id where you would usually reference it in your formula. Voila! I hope that helps!

 

Did this topic help you find an answer to your question?

3 replies

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Really clever! Thanks @GetUWired 


GetUWired
Forum|alt.badge.img+12
  • Author
  • Zapier Expert
  • 1030 replies
  • December 2, 2020

Thanks @AndrewJDavison_Luhhu !

Of course right after I figured this out Troy Tessalone pointed me in the direction of ArrayFormulas and I ended up going that route to save a task. 


andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • December 6, 2020

(Adding that here just to save people arriving here, and going hunting for it)

 

https://support.google.com/docs/answer/3093275?hl=en