9

Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am trying to figure out the best way to handle that. Would I only be able to do it using workflows, or can I actually use the timeline? I'm thinking if I do it that way, I would have to manually change the dates every year. Also, that template came setup with 'dependencies' for dates set up. I'm trying to figure out if I should keep that on or turn it off. Any feedback would be very welcome. Thank you!

Comments

Depending on your use case, it may be easier to enter all of your tasks and leave the dates as blanks.

 

You can then call this (or even save it as) a template, and then use either save as new or create new from template to easily replicate the basic layout and data. Then you would just have to enter your dates. 

 

If you don't really need dependencies, you could even go so far as to turn them off and use formulas to automatically populate the dates based on whatever year you enter into a specific cell within the sheet.

In reply to by Paul Newcome

So, basically re-create the tasklist every year? I guess that's one way to do it. I was hoping for something more automated, but I can't seem to figure out how to do that except through workflows; but then that wouldn't be visible to the average person. 

Andree_Stara

In reply to by Mary Vogt

Hi Mary,

You could also create one sheet with everything set up and then copy that down the same sheet for the coming years. It's a matter of preference and specific need.

It could also be structured to only show what's relevant.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

work-bold

In reply to by Paul Newcome

I wish there was a way to view how the templates work before selecting one. I am now thinking perhaps I chose the wrong template. 

Some of our tasks span 5 years, some  are annually repetitive, and I have them all in the same 'calendar'. 

Perhaps the System Development Life Cycle with Gantt is closer? 



 

Andree_Stara

In reply to by Mary Vogt

No worries!

You can quickly move/copy the rows to another sheet.

I agree with Paul, and it sounds like the best way to structure a solution would be to start from scratch and work from there or look at a template that might help after the structure is complete.

Make sense? What do you think?

If you want to start with a template I'd recommend one of the following:

https://www.smartsheet.com/marketplace/templates/content-calendar

https://www.smartsheet.com/marketplace/templates/annual-calendar-day

https://www.smartsheet.com/marketplace/templates/project-task-list

Would they work/help?

Andree_Stara

In reply to by Mary Vogt

Do you have something that you could share that would show what you'd want to accomplish? (Screenshots, Exel sheet or something else) (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

My apologies. I misread your original post. I read it as all tasks would be completed at some point throughout the same calendar year.

 

Reading it again along with your additional comments I see now I was wrong.

 

If you chose the wrong template, you can delete the sheets/folders/etc. relatively easily and choose another.

 

I am not very familiar with the templates though as far as which one may better suit your needs. I generally end up having to build out my own solutions so that they can work exactly how I need them to.

 

 

Again... My apologies for the misunderstanding.

 

In reply to by Paul Newcome

Thanks, Paul, there are no wrong answers! ;) 

I appreciate you replying. 

I don't think I was clear enough. I am now also wondering if a dashboard approach may be better... I am basically trying to form a planning calendar system with some one-offs, some annual, bi-annual dates, some 5+ year plans/goals, etc. All in one entity. And there are about 5 different categories of tasks.

So far, I haven't found a template that works, but if I do, can I copy all of my info into a new one easily?  I have had trouble trying to copy and paste rows in the past.

Andree_Stara

In reply to by Mary Vogt

I wouldn't recommend starting with a Dashboard. It's better to get the sheet structure set first and then structure the Dashboard as needed.

You can quickly move/copy the rows to another sheet. (right-click or use the little menu on the rows to move/copy the rows)

I hope that helps!