Is there a way to filter iCal by Sheet levels?

08/06/21
Accepted

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.

Tags:

Best Answer

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    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

Answers

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    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 @ChessAdrian @Chess ✭✭✭✭

    Thanks Genevieve, I'll add another product request.

Sign In or Register to comment.