Sheet Summary Report - Gantt and Calendar View

Rannie Xu

Right now with sheet summary report, if a formula is being used to populate sheet summary data (e.g. =[Start Date]1), the date can display properly on sheet summary report in Grid view but it will prevent the date from being used as a date on Gantt view or Calendar view because it's a formula not an actual date despite that I created the sheet summary field as a date field format and my date on my sheet is also formatted as a date.

It would be nice to change this so that when pulling multiple sheets' sheet summary, I can still display all the start date and end date of the projects via Gantt view and also display them on calendar view.