Formulas to link cells
With the recent expansion of formulas to cross reference other sheets I would love to be able to split projects to other sheets. If I could pull the Primary column and the Start Date column via formula I could have secondary sheets that have their own unique information.
The new help sheet here, Referencing Data from Other Sheets, says you can reference entire columns with your formulas. However, when I try to draw direct references to another column through the range picker it says "#INVALID COLUMN VALUE" I can individually draw the reference "=B1" when B1 is on another sheet. However I cannot "=[Column1]:[Column1]" through the range picker?
Thanks for your thoughts.