Organize formulas on a sheet

I have many formulas on a sheet which are linked to another sheet and the result is picked up on a dashboard. On the sheet i have added extra columns to place the labels but these column fields then show on the kanban card view which i don't want.

So question is how best to organise formulas on a sheet, is the below screenshot of what i have currently set-up the best option, which becomes quite messy after a while?

Thanks,

Neil.

Find more posts tagged with

Sheets

Sharing and Collaboration

Formulas

Card View

Comments

Richard Rymill SBP

Neil

Have you tried placing all your columns holding the calculations for your Dashboard somewhere off to the right of what you do want to be seen? Then hide them to avoid clutter.

That is the normal way of solving this?

Hope that helps

RichardR