INDEX() function help
Hi,
I have a master list of tasks in one sheet with project specific labeled columns. I'd like to break out those columns into separate sheets. My thought is the best way to keep the master list current while transposing data, using a combination or INDEX() and MATCH() functions would be best but am interested in any suggestions.
Does anyone have any formula recommendations for transposing data to multiple sheets from a single data source?
Thanks.
Answers
-
I am sure there are multiple ways to do this, but I think DataMesh is a much more robust solution than the formulas you would have to maintain. I will provide the link for the DataMesh abilities below:
https://www.smartsheet.com/marketplace/premium-apps/datamesh
Help Article Resources
Categories
Check out the Formula Handbook template!