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.
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.
*
George Carlisle wrote:About this comment..."check data on the daily sheets" There is no data. The screenshots I posted "PULL" data from the other sheets.
I'm referring to the file you uploaded. The daily sheets contain data.
Did you put the formula in D23:D46 on every sheet and do the results make sense for you?
- Let's solve the problem first then we'll talk about simplification of the spreadsheet.
Why are some of the fields populating and other's are not?Detlef_Lewin is correct. You have spaces in your cells not blanks. Go to ='Day19'!B23 and clear contents then check your summary sheet again.
