Calender based on a report

Matt Penta

I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either 

A: Be able to format the calendar on the report(I know that reports take conditional formatting from other Sheets, Would I have to format the calendar on every sheet to meet my needs on the report that is run?) or

B: Create a sheet that can mirror the information on the report and update as the report is run/changed. Copy and Pasting the information is not ideal since I may want to see a different view for specific date ranges or projects etc. 

Andrée Starå

Hi Matt,

You'd need to format it on the different sheets.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Matt Penta

Thanks, that is what i suspected. I will adjust my template/sheets.

Andrée Starå

Happy to help!