collect
Discussion List
- I have a main table that, given the team(s) involved in a project, needs to look up the contact info for members of all of those teams. ([Teams Involved] is a multiselect dropdown, and [Members of Inv…
- I am looking to cross reference Sheet A to pull in Time slots from Sheet B. Criteria I need to have matching from Sheet A to pull from Sheet B to determine the slot number or multiple numbers. Start T…
- Hello to everyone. Im starting to go deeper into advanced formulas and sheet reference, but have some issue... I have a "customer activity" sheet, where for each line, there is 2 sets of variables (5 …
- I'm working on a multi-sheet solution for my PMO and have been using Index and Match to pull specific information from a metadata sheet into matching cells on other sheet using INDEX/MATCH. I've been …
- I am attempting what I thought was a simple formula to collect a value from the 'Week" column if today's date falls between a Start Date and an End Date. Here's what I have so far which returns an #IN…
- Hi, I'm trying to revise a formula and am a bit stuck on how to do it. I would like to pull resource utilization information from my Project Plan into a Team sheet (and no, we don't have the Resource …
- (We cannot use Zapier Integration). So, I created a Data Shuttle to pull the information from the Zoom attendance report. However, I need to Index/Collect how we designate the entity that they are ass…
- Hi, I am setting up two very similar sheets, with the same columns and similar data (each sheet is for a different date range). In both sheets, I have a column that uses a MIN/COLLECT function to dete…
- I have a working formula where I need to add one more criteria to a COLLECT function but can't seem to get it working. Here is the current working formula: =MEDIAN(COLLECT({Platform Test - Submit Stat…
- Hi, I am trying to list all the distinct values for the Year 1 through Year 4 columns but only for the rows the WBS row value is equal to WBS Target value and skip any blank cells. I have a helper col…