Forum Discussion
Office365 / US English ->I get blank cells when I program formulas to pull values from other sheets
Office 365 on Windows 10 Details:
Check the data on the daily sheets.
=LEN(B23)>0Apart from that the model can be simplified.
16 Replies
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.
