Pasted rows are automatically indenting
I have come across an issue. I have a dummy project I created with the parent/child formatting management has agreed on (Project/Parent; Task/Child). This lives in row 1-8 of our sheet.
The idea is that when a new project is created this dummy should be copied at row level and pasted into the next available space at the bottom of the sheet.
This went well until we rolled it out, now it seems that when the information is pasted it is automatically indenting. So, now it appears to roll up to the project above it and that is messing with a formula in one of the columns to pull the parent name. Once we click in the parent row and use CTRL + [, everything is as it should be but is there a way to prevent that from happening??