Sep 11 2020 10:21 AM
Hello,
I need help with a formula that will pull data from my Client's tab (when the column cell is changed to "needs drawings") into my Daily Tasks tab. There will be hundreds of entries and the cell will change for each client as the sales cycle progresses;- they will not change in any order of row. Attached is an example
Sep 11 2020 11:13 AM
I've attached a file with a formula that I believe will do what you're looking for, but have you considered just filtering the Client list for "Needs Drawings" (Data tab, Filter button)?
Sep 11 2020 02:14 PM
These days
= FILTER( clientData, Tasks="Needs Drawings", "None")
returns the extracted data as a single array, sized by the data.