Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Organize formulas on a sheet

Neil Spencer
Neil Spencer ✭✭✭
in Archived 2017 Posts

Hi

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.

Formulas.PNG

Formulas.PNG

Tags:
· Share on FacebookShare on Twitter

Comments

  • Richard Rymill SBP
    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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories