Calender based on a report

Matt Penta
edited 12/09/19 in Formulas and Functions

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. 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!