Is there a way to filter iCal by Sheet levels?

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.

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    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!