Need help to create a weekly schedule in Smartsheet based on the table below

Sibali_B

Can I create a weekly schedule similar to the one above in Smartsheet

Paul Newcome

Technically yes, but it is going to be extremely rigid. My suggestion would be to have the dates going down one column and then each instrument/time slot as other columns.

Dates.....Inst A Morning.....Inst A Afternoon.....Inst B Morning.....Inst B Afternoon

Paul Newcome

Technically yes, but it is going to be extremely rigid. My suggestion would be to have the dates going down one column and then each instrument/time slot as other columns.

Dates.....Inst A Morning.....Inst A Afternoon.....Inst B Morning.....Inst B Afternoon

Sibali_B

Thanks for your comment. It indeed seems rigid. I was trying an alternate way. My grid view is this:

In the calendar view for the same, I see this

I want to be able to add the instrument name and the user in the calendar as well eg. for August 24th, with Project 1 it should also show ELSD1 and Sibali Bandyopadhyay as well. How can I do that ? Please help.

Andrée Starå

Hi @Sibali_B

I hope you're well and safe!

You can combine multiple cells, but you'd have to add them to the Task Name (Primary) column.

You'd have to move the Task Name to another new so-called helper column.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sibali_B

Thanks Andree for this information. How can I combine "Task Name", "Instrument" and "User" in a Primary Column which would be the helper column. Thanks

Andrée Starå

@Sibali_B

Happy to help!

Try something like this in the Primary Column (Task Name)

=[Primary Helper]@row + " - " + Instrument@row + " - " + User@row

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!