Forum Discussion
Flash fill not working when working with values from pivot tables
I am trying to flash fill my formula in column K of my attached spreadsheet. But it does not seems to work. My input values are obtain using pivot tables. Basically I am trying to read values in column D,F,H using if function and combo box. This is because I want t create chart in dashboard after this.
2 Replies
Liphor See attached. When you select a cell in a pivot table the link is not dynamic. You need to go in and exchange the hard-code years to cell references.
- Noted.Thank you
