-
Index Collect Formula Assistance
I want to lookup a specific start date based on 2 criteria: (1) Workset; (2) Week # in the main sheet. I have a separate sheet that contains the dates I am pulling in. I tried using INDEX(COLLECT and I can't seem to get it to work. Data Set: Workset Week # A, B, C, D 1-12 Example: If you have Workset A and Week # 5 the…
-
Best way to populate multiple invoice #'s in a single cell
I'm trying to combine multiple invoice #'s while referencing a daily/weekly record ID #'s. I tried using the Join/Collect function and could pull some of the invoices if there is only 1 daily/weekly record ID #, but can't pull the invoice # if there are multiple daily/weekly record ID's in that column. Is there a way to…
-
INDEX COLLECT over multiple documents
I am looking for your help once again :) So the below formula works fine for me however I have other sheets that I also need to reference. I'm assuming I would need to add an AND or OR formula to the below however I'm not sure where or what structure the formula should be. And its to reference another 4 sheets, including…
-
Which formula can be used to extract the values with in bracket in a multi value cell.
I have a dropdown containing multiple values and I need to extract only the values like [CDB0040] [CDB0038]
-
Column Linking Not Working - What am I missing?
I'm the admin of a workspace which contains 2 sheets: 1) "Source Dropdown Sheet" which should function as master dropdown list to feed other sheets (sample a US State dropdown column), and 2) "Source Sheet 1" in which I'm attempting to link the State column to reduce copy/pasting. However, after going through the process…
-
When Predecessor Completes Mark next task to In Progress
I am struggling finding a formula to mark the successor task "In Progress" when predecessor is "Complete" like can be done in MPP. I am encouraging my organization to move to SS with the automation, reporting, dashboard and automation capabilities, and away from MPPP so trying to replicate some of the items they utilize in…
-
Trying to compare cells to update dates
Trying to find matching serial numbers, then use delivery date of the first entry to derive support date of 2nd entry. The below works for the initial entry but the Extension Order gets #Invalid Data Type error. Thank you in advance for your suggestions. =IF([Order Type]@row = "New HW", DATE(YEAR([Delivered Date]@row ) +…
-
Formula to calculate # of Projects per Month
So I keep getting #unparseable from my formula below. =COUNTIFS({Creative Marketing Request Tracker Range 5}[Start Date]:[Start Date], <=DATE(2025, 11, 30), [End Date]:[End Date], >=DATE(2025, 11, 1)) I have a lot of projects with different "Requested Delivery Date" (column header). Above I attempted to find how many…
-
Counting cells with two rules
Column with multiple drop down options (cities). Some submissions have one city specified, some multiple. Followed by four optional columns (Brand 1, Brand 2, Brand 3, Brand 4). Not all entries have four brand entries, some 1, some 2, etc. I would like to have a count of the number of brands (cells that are NOT blank) per…
-
How to populate valid resource rates from a source table, for each week of a project.
I have a Resource Table with… Resource ID Name DailyRate ValidFrom R01 Resource X $1,500 3/8/25 R01 Resource X $2,000 9/1/25 R01 Resource X $2,200 9/31/25 I also have a Week by Resource Table with… WeekID ResourceID WCDate ValidRatePerWeek W01 R01 3/2/25 auto-pop $1,500 W02 to W26 R01 All the dates for W02 to W26 auto-pop…