I run a residential construction company and have almost every aspect of the business running through Smartsheet.
This has led to the template for our 'standard home' now containing 105 columns!
The bulk of these are for calculations and automation, and are only required for specific processes when creating a new project.
I have created a instruction list for setting up a new job, and this requires having only certain columns showing, currently we are hiding the unused columns. The problem with this is you then have to 'unhide all columns' when you want to see one again, and then hide them all again.
Ideally, i would love a 'column filter' which would allow me to preset views for working in.
I know reports look like the answer, but they are limited to not allowing for a row to be added, and also the conditional formatting does not update immediately which makes them less visual to work in.
Anyone have any ideas/suggestions as to how i can work around this issue?