When creating a new spreadsheet row, is there a way to use the new input data on formulas that are wating on dormant unedited cells on that row? For example:
I create row with data on cells A to C. Cells D to F are blank but have formulas that use references from cells A:C. Zapier behaviour seems to be deleting the cells that are not supposed to be filled with data.
I could try using update row instead of creating a new row, but for that to happen I'd need to be able to identify the first blank row from the bottom as the one to be edited. Is this possible?
Thank you in advance