How to pull data from another sheet based on a specific criteria
I have one sheet that includes all of our projects listed in rows and I need to create specific sheets outlining the tasks for each of the rows. The new sheet should also include specific data (such as dates, names, etc.) from the first sheet. I'd like to be able to link data from specific cells from that first sheet to the new sheet automatically when the name of the new sheet is changed to the title of the task in the original sheet. For example, if the new sheet includes the title of row 7 from the original sheet, cells in the new sheet will be formatted to automatically populate data from row 7 where the details of that task are included. Is this possible?
Help Article Resources
Check out the Formula Handbook template!