alternative to Merging cells in Smartsheet

Mashael

I want to create a grid sheet that is similar to this:

I know merging cells is not possible in Smartsheet, but is there any other way to achieve this?

thank you so much !

Hollie Green

You can use a multi-select dropdown for the courses it would look something like this

Mashael

Thank you so much for your replay!

what if I do not have fixed values and I want the user to type in the value

let's say I want the user to enter the sales quarterly as follows:

the sales will change and I can not use a multi-select dropdown.

Is it possible?

Genevieve P.

Hi @Mashael

As an alternative. what I would suggest doing is use individual rows with the Item duplicated in each row. Then if you're on a Business or Enterprise plan, you can use a Report to Group by the Item column to have a header-row automatically created.

See: Redesigned Reports with Grouping and Summary Functions

Cheers,

Genevieve