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!
