How do I add a sheet tame to calendar view when running a report?
I'm working on a production schedule. I have multiple smart sheets for tracking each job's production dates, such as drafting, procurement , production, etc. The I run a report to create a calendar so that I can visually see where each job is sitting on the calendar so that I'm not over scheduling.
Problem is each individual smart sheet has the same task names, so when they show up on the calendar I'll just see something like multiple entries for "production". What i really need is to precede, or proceed (I don't care), each task name in the calendar with the sheet name, so that it looks more something like " PE0566 NKC Casework - production".
I'll attach a couple of pics of what I'm running and the output, so that you can see with having "production" twice on the calendar is a bity confusing, even though they come from separate sheets. I limited this to 2 projects for simplification of my example. In actuality I have about 6 that I need to plug in here at the moment, but the list will be growing.