Hi everyone,
I’m running into an issue with the Pigment Google Sheets Connector shifting existing formulas in adjacent columns during data syncs.
The Setup:
-
I configured the Pigment Connector to start exporting data at cell B1 (leaving Column A open).
-
Column A contains custom formulas designed to calculate alongside the imported data.
The Issue:
-
Every time the connector runs, it pushes the formulas in Column A down beneath the bottom of the imported dataset, rather than keeping them aligned in rows 1 onwards alongside the newly exported data.
Expected vs. Actual:
-
Expected: Data populates starting at B1, while Column A maintains its formulas side-by-side with the imported rows.
-
Actual: The connector appears to insert/clear full sheet rows, bumping all existing Column A formulas below the last row of the export.