How to create similar view in Smartsheet?

Options
EvaL
EvaL
edited 08/31/22 in Smartsheet Basics

Hi,

Is it possible to create the similar view like on presented screenshot from excel?

I need calendar on the top with years, quarters and weeks and below I need to have possibility enter the numbers (only) for each week. Besides that I need to also add rows with text only (test name) like in gantt view. I was able to combine it in excel but how I can convert it to Smartsheet? It doesn't have to be identical but I appreciate some ideas? If this is not possible I would appreciate any idea how to add just numbers of tests assigned to particular weeks.


Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @EvaL

    The closest configuration I can think of would be to use a Gantt view in Smartsheet.

    Each different number would need to be its own row, so you won't have one long line broken into multiple sections. Instead, you'll have a staggered view as it flows down the sheet and across your Gantt chart:


    Cheers,

    Genevieve

  • EvaL
    Options

    Yes, I did it first the way you suggested but our worksheet become too long and it is missing a purpose. I see that others requested the enhancement for the same but its pending 4 years already...