Report not populating with formula column data?

estradamee

Hello,

I have a group of sheets that populate a report with date data. One of the date columns is a formula column that is constant through all of the sheets, used to track various processes to calculate a target end date. For some reason, the data appears on the sheet but does not populate on the report. It appears on the report for some sheets but not all sheets. And even appears for some items on the same sheet…

It is important to track these target end dates to ensure timely production and deconflict bottlenecks. Our team has regular meetings that are heavily reliant on looking at all of the things in production to determine priorities and the target end dates are vital to this planning and expectations for these items.

How can I ensure that this data that is present on the sheet also appears on the reports consistently?

Many thanks to the community in advance.

Darren Mullen

@estradamee check that the column type is the same for the sheets that show it in the report and those that don't

estradamee

@Darren Mullen

I confirmed all of the columns are set to date columns and restricted to dates. When opening the sheet from the report sheet name link, all of the data is missing, then has a latency period of a second or two, then the column formula operates as expected. I have tried different browsers, clearing cache, removing some memory settings. Nothing seems to be able to display the information consistently.

Should I submit some sort of request to Smartsheet directly to debug this issue?

Darren Mullen

@estradamee Sounds like you'll have to. If you have a lot of heavy formulas in a sheet and cross sheet links, it can slow performance.

estradamee

@Darren Mullen Ok, thanks very much for your responses / insight.