Summary tab – cell F30:
– You have a drop down menu (“yes, no”), plus you have a formula in the cell =IF(Construction_Module_On?=TRUE,”Yes”,”No”). My question is which variable governs, the drop down menu or the formula? Problem I see is if you change from default “No” to “Yes” and then back to “No”, you lose the formula.
Cell Summary!F30 is a calculation cell (black font) and not meant for user input. However, I see the confusion – with the letters being small it’s hard to tell the font is black plus, with a drop-down menu in the cell, it appears to be an input cell. I’ve gone ahead and removed the drop-down menu to hopefully remedy the issue.
