one task through multiple calendars

I'll try to explain what I'd like to accomplish.

My task name has sub-tasks for example "custom","boxcut", "assemble","finish" that populate calendars.

On the calendars they show all of the "custom tasks" for all main jobs.

How would I setup a calendar to show all the sub-tasks for just the selected task. Such as the linear gantt chart but show in calendar form. So I can see the one Main Task over the 3 month period in all sub-tasks.

Hopefully you understood that.

thanks

Find more posts tagged with

Manufacturing

Calendar View

Project Management

Comments

Schiff A.

Hello,

It sounds like what you want to accomplish is to filter your calendar view to show only the tasks that belong to a single parent task.

This can be done by using a checkbox column in conjunction with a filter.

To do this:

1. Create 2 checkbox columns. Label one "Show on Calendar" and the other "Calendar Subtasks"

2. In the "Calendar Subtasks" column enter the following formula in every cell: =IF(PARENT([Show on Calendar]@row) = 1, 1, 0)

Now, when you check a box in the "Show on Calendar" column that corresponds to a parent task, it will check all of the boxes in the "Calendar Subtasks" column for all of its sub-tasks.

Once you have checked to make sure the boxes are being checked appropriately, you can hide the "Calendar Subtasks" column.

3. Create a filter that shows rows where "Calendar Subtasks" is checked: https://help.smartsheet.com/articles/504659-using-filters-to-show-or-hide-sheet-data

To use this filter, check the "Show on Calendar" box for the parent task you want to see. When you switch to Calendar view, only that parent's subtasks will be displayed.

I hope this helps.

Thanks!

Schiff

Smartsheet Support

IFCC

Wow, that is awesome. I've been wanting to do this for so long. It is incredibly helpful to me. Works great.

Thanks so much

Mike

IFCC

One further thing I noticed would be helpful. I have the task name showing up but wonder if it's possible to combine the Assigned to column with it, just for the new calendar sub-tasks filter?

I can format it in colors but I'm partially color-blind so colors really aren't something I use much.

thanks

Mike

Andrée Starå

Hi Mike,

You could add a new column that combines the information.

Please see attached link/screenshot.

https://cl.ly/pisz

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

IFCC

Yes that would work very nicely.

Pardon my inexperience. How do I edit the filter to show the new 'Combined' row data instead of the Task name?

I can do it in the Gantt chart but can't figure it out for the calendar view.

Andrée Starå

I forgot to tell you that the combined information needs to be in the Primary Column because it's shown in the calendar view.

Will that work for you?

IFCC

I might have to fiddle with it a bit to see.

I use the primary column info for other calendars.

thanks

Mike

Sign in to join the conversation!

Quick Links

Trending discussions

Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…
Workspace is still there but all folders are empty
Hey, I had a Project in January where I created multiple sheets, dashboards etc. Now I want to prepare the same project again but all folders are empty. Not a single sheet is left. How is that possible ? I upgraded to a paid account during that time and Iwanted to do that again but smartsheet do not delete everything if…