Suddenly formulas not showing in report

Remko_TVAA_services

Hi guys,

 

i really think i am overviewing something so maybe you can help. It seems simple but just cannot figger it out.

I have a report with formulas extracting from serveal sheets. We need so see the formula because it includes information we need. For example: in a sheet a ceel is 20*5 it meens sizes of a advertisement. So in the report you see the formula and by mousing over you immediatly see the size 20 x 5. Very easu. But just a week or so ago it stopped showing these formulas. We see a formula sign Fx pop up under the cell, but we dont see the formula while we knopw its there because cell like in example says 100. So its there, its in the sheet, but in the report not showing. We looked all options, roles do not do it, and are not changed, sheet is desame no changes.

Did something in smartsheet maybe chaned? I looked everywhere here, and cannot find it. Support is not reacting so maybe someone cab help, or any idea?

Thanks,

Remko

Andrée Starå

Hi Remko,

Could you share the sheet(s) / report(s) or provide some screenshots?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Remko_TVAA_services

Hi Andree

Thanks for reacting! I dont have any screenshots now. What you want to see? Any questions about the problem maybe?

I can do it but i am afraid you do not see anything...

Andrée Starå

Happy to help!

I just double checked some of my own and my client's reports and I can still see the formulas when I hover over the cells.

So it should work. How are the reports shared?

 

Remko_TVAA_services

Andree thank you for helping! 

I tried to make s screenshot but does not show the problem. What it is strange now i do this i see one cell when i click it it has a grey border and i see the outcome of the formula but no formula and no little sign of Fx. One cell below i click once and see the outcome of the formula but it has a blue border AND i see the Fx little box appear (where i cannot do anything with it) in the report. The report is build with 5 sheets. I checked in sheets is nothing changed. It seems somehow its not transporting the formula to the report. Still nothing changed in the sheets have desame sheet settings and columns and rows but once has the blue border and one a grey border with no formula.

Sorry for no screenshots but anytime when i do that it undo the cell selection so i tried to explain as best as possible... 

Andrée Starå

I tried in another report, and I have the same issue as you. I've had this issue before and solved it then, but just now I'm drawing a blank on how to fix it. I'll get back to you as soon as I remember.

Andrée Starå

Are you still having issues?

Best,

Andrée

Remko_TVAA_services

Hi Andree unfortunately yes. Still have the problem. Support told me it's a known issue and I have to keep watching the website for updates. Of course that's not a great solution. When I hear things like this it gonna months or years. And it suddenly changed without we doing something. 

You have this issue too?

Andrée Starå

Ok. Good to hear that it's on Smartsheet Supports radar. I don't think it will take long before it's fixed. I'm also having the issue but not so much as you, it seems.

Have a fantastic weekend!

Best,

Andrée

Sangeetha

I also have the same issue with a Smartsheet report which doesn't pull the (content) in a column that has a formula from a selected sheet. I see that there is formula when I hover over the cell and if I select via cell history that the content is there but doesn't display upon view of report

I see this forum community mentioned the issue from 2018 however the issue still continues to be unresolved. Is there a solution to this matter by selection an option to have it display on the report.

Caroline Henne

Has there been any resolution to this issue? I am having the same problem that a report doesn't pull the content from a formula column - in the report, the cell looks blank.