I have a report I've been using for months.
Reached a cell linking limit in the original sheet so made a copy of that sheet, renamed it and modified. Plan is to now limit sheets to Q1, Q2, Q3, Q4 time periods in order to stay under the 5,000 linked cell limits.
So Q1 is the original sheet with columns deleted to only contain Q1 time periods. Q2 is the copied sheet that will contain only Q2 time periods. See Report-SourceQ2.png to see the columns and data displayed in the sheet.
I edited the report to now include both Q1 and Q2 sheets, then use the Column button to add Apr 15, Apr 30 & May15 columns from Q2 sheet.
Columns from both Q1 & Q2 sheets show up in report, but only Q1 data is displayed. Q2 columns are there, but no data shows up. Please see Report1.png and Report2.png
I have exited Smartsheet, closed Chrome, restarted Chrome, reloaded all the client sheets and reports, multiple times, but no change.