Can a calendar view of a report reflect the formatting/formating of the underlying sheet or report

Joseph Farahat

Hello everyone!!

We use a sheet to schedule staff for events.

We have about 30 to 50 of those folks. We use the update request for them to accept or not.

We are in a fast-paced industry where things change often and rapidly. To help them continuously see where they stand, I have built a report for each person. I then have scheduled that report to be emailed every two weeks and it includes the published link to that report for them to bookmark and look into the system at any time. Everything works great except...

 

If by accident the person hits the calendar view on the report. That does not reflect the proper information. See images.

We played around with any dates that are cancelled to be moved to another sheet. That adds confusion because people start to question their own memory. We have found when we give them all the information it keeps them organized.

Can the calendar view of the report reflect the formatting of the underlying sheet or report?

Thank you in advance!!

Genevieve P.

Hi @Joseph Farahat

In Calendar View, the Task Bar is the colour of the bar shown in the square.

This means you'll need to adjust the colour of the Task Bar in your Conditional Formatting rules. The other formatting will only apply to the cell in the Grid View:

Cheers,

Genevieve

Genevieve P.

Hi @Joseph Farahat

Yes, formatting in a Report will reflect the underlying sheet formatting. However it sounds like you have formatting applied to cells in rows, but not on the Task Bar of each task, which is the colours reflected in a Gantt or Calendar view.

You can set the format of Task Bars using Conditional Formatting, as long as the format is applied to the "entire row", and this will reflect on the Report too.

See: Change the Color of Task Bars and Apply Formatting Automatically with Conditional Formatting Rules

Cheers!

Genevieve

Joseph Farahat

Hi Genevieve,

Thank you, I am back on this project.

The above is not a gantt chart.

The parent sheet is set to "entire row".

Genevieve P.

Hi @Joseph Farahat

In Calendar View, the Task Bar is the colour of the bar shown in the square.

This means you'll need to adjust the colour of the Task Bar in your Conditional Formatting rules. The other formatting will only apply to the cell in the Grid View:

Cheers,

Genevieve

Joseph Farahat

Hi Genevieve,

amazing, thank you.