Found bug when moving rows across sheets
The system generated created field is NOT updating.
The highlighted box of rows were added in the last week through an automation on another sheet.
I still can't find how to submit errors/bug/enhancement requests.
Best Answer
-
"Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet."
That happened when I renamed the existing system "Created" column, hid it, then created a new column with the same name.
So, then, I deleted the destination "Created" column and reran the automation. Now, it's behaving as it should.
Thank you.
Answers
-
Is the Created column on the receiving sheet a text/number column?
-
No. It's the system column.
-
Ok. What happens if you change it to a text/number column, hide it, then add a new column to only the destination sheet for the system generated Created (date)?
-
"Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet."
That happened when I renamed the existing system "Created" column, hid it, then created a new column with the same name.
So, then, I deleted the destination "Created" column and reran the automation. Now, it's behaving as it should.
Thank you.
Help Article Resources
Categories
Check out the Formula Handbook template!