Is there a way to filter iCal by Sheet levels?

Adrian Mandile CHESS

I would like to only show a specific level within a project Sheet's work breakdown structure, so that in an external Outlook calendar, it only shows the level 3 (i.e. task/activity) rows but not the level 1 (project) parent/summary row or level 2 (stage) parent/summary rows - as these all dates also.

PS: this is not the same as unticking the Calendar Settings | Display Summary Tasks - that by the way only removes the top level (project) parent/summary rows anyway.

Genevieve P.

Hi @Adrian @Chess

No, there currently isn't a way to publish a filtered version of a sheet to iCal. You would need to set up a separate sheet to house just the level you want to see and then publish that instance instead (potentially with cell-links or cross sheet formulas to keep rows synced between sheets).

Please let our Product team know about your use-case and request by filling in this form, here!

Thanks,

Genevieve

Genevieve P.

Hi @Adrian @Chess

No, there currently isn't a way to publish a filtered version of a sheet to iCal. You would need to set up a separate sheet to house just the level you want to see and then publish that instance instead (potentially with cell-links or cross sheet formulas to keep rows synced between sheets).

Please let our Product team know about your use-case and request by filling in this form, here!

Thanks,

Genevieve

Adrian Mandile CHESS

Thanks Genevieve, I'll add another product request.