Forum Discussion
Office365 / US English ->I get blank cells when I program formulas to pull values from other sheets
Check the data on the daily sheets.
=LEN(B23)>0Apart from that the model can be simplified.
Here's my issue, I have marked the cells that don't populate. If you can't read it, then you need to download and magnify the image).
This is the same sheet with the formulas reveals so you can see that my formulas are correct.
I have frozen the first column and have broken the views (revealed formulas) into two screenshots.
First Part of the Spreadsheet
Second Part of the Spreadsheet
Problem Summary:
This spreadsheet summarizes data from 31 sheets that are in the same workbook.
Most of the fields functioned correctly and copied blank cells as zeroes in the summary spreadsheet. A few of the fields were unable to do this despite me recreating and recalculating the summary sheet 3 times. Also, I have validated my formulas again and the proof they are correct is in the screenshots above. I believe this is a bug and I need Microsoft to assign an expert and record this for bug testing. I will attached the complete spreadsheet here zipped for further inspection.
Check the data on the daily sheets.
=LEN(B23)>0Apart from that the model can be simplified.
About this comment..."check data on the daily sheets" There is no data. The screenshots I posted "PULL" data from the other sheets. I can post all 31 sheets and location but the formulas tell you where the data is pulled from. Also, I have already gone to those sheets and cleared, put fake numbers and results still the same when back to blank.