Sign in to join the conversation:
We have created some filters in our production sheet but when we remove the filter the data does not return to its original order in the sheet. is there something we need to do or something we are missing to prevent this from happening?
Filters should not change the row order.
Can you explain in detail what is occurring? Is someone sorting data after it has been filtered?
Craig
I would have thought that the filter when turned off should not effect this as well. The sort function has not been used. So we have work ordered into weeks of the year week 38,39 & 40. when the filter is turned off some of the date moves into weeks they should not be in i have attached a screen snip.
That seems really weird. Filters don't actually change the data, they just change which rows you see at any given time
Is the week of the year a formula or calculated field? if so, what is the formula?
so the week is a manually entered field as it changes to often to automate.
Then the filter really should not be changing the data. Maybe someone is copying and pasting or inserting new rows while the filter is selected?
Is there a way to copy a row into multi sheets without doing it manually? Be able to choose sheets and copy a row of data into new sheets. We have construction schedules build and want to add new tasks to sheets
I have an active automated notification in a sheet of project tasks that lets the "assigned to" know when anything has changed in their row. However, they don't need to know about changes they made themselves so I am trying to eliminate those. I set up a column called "MATCH" and added a formula to check for a match…
Hi, I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display. This is the name of the value that doesn't…
