Home > Enterprise >  Applying array formula for rows with existing data
Applying array formula for rows with existing data

Time:05-31

I have trouble creating automation using Google Sheets. I use array formula for converting duration format from one column, to make it understandeable for Google Data Studio, however, my autiomation, when there's no existing project, needs to append a new row. But if there's an array formula applied to a column, it has created 0 values for 1000 rows, and my new row gets appended as 1001. How to fix that?

Maybe I could somehow limit the array formula to work only if there's data in the row?

I tried to find other variant of array formula from here, but none of these worked, enter image description here

  • Related