Hey Guys,
I have created a sheet to help our construction company track our new leads. We have set it up to fill out a form that feeds information into the sheet. I have conditional formatting set up to identify each lead by their status. Periodically I will pull out dead leads and move them to a parent category allowing me to collapse some of the parent categories to keep the sheet less cluttered.
My issue is with sorting. At any given time we may have 30 or more open leads that haven't been "filed" as dead, or active. When I sort by the primary column it also moves my parent categories. I would like to keep my parent categories at the bottom, since that is my form of "filing" leads I no longer need. My solution was to name the parent categories Z "example", then ZZ"example", and so on.
Does anyone have a better solution for keeping my parent categories alone when sorting?
If not, is there a way to create a hidden label were the "Zs" would not be visible but would still be recognized when sorting?
