Hi everyone,
I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this.
Here’s the setup:
- I have a sheet where, when I check a box, the row moves to a “Completed” sheet.
- In my Total column, I use a formula that sums a group of cells tied together via a parent/child relationship.
- When the row moves to the Completed sheet, the formula normally converts to a static cell value (which is fine, since I only need the value at that point).
- I have the same setup for two other columns, and it’s been working the same way.
The problem:
Recently, when the automation moves rows over, one of the columns is no longer carrying over the total value correctly. Instead, it’s pulling over the other formula‑based values. What’s odd is that this only happens in one column—the other formula columns still behave as expected.
In the screenshot below, you can see that columns B and C are formulas. Column B drops off after the first few rows, but column C doesn’t have this issue.
Troubleshooting I’ve tried so far:
- Double‑checked the automation settings to confirm it’s set to “move row” (not copy).
- Verified that the column types match between the source and destination sheets.
- Tested with a new row to see if it was a one‑off issue (it wasn’t)
Has anyone else run into this behavior, or know why it might have changed?
Any feedback is greatly appreciated!
SOLVED - FOUND OUT SOMEONE ADDED A DIFFERENT COLUMN WITH A SLIGHTLY DIFFERENT NAME TO DO THE SAME
