-
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…
-
How to get total count for projects releasing now through the next 3 months
Hi all, I am looking to count the number of projects due to release within the next 90 days. The closest I've gotten is: =COUNTIF({HCCE input sheet Storage Range 3}, <=TODAY(+90)), but it returns a count of zero even though there are several projects within the next 90 days. Any help greatly appreciated.
-
Which is the right formula to join the text in multiple cells.
I wanted to join the text(PM names,ID) in two or more cells which is basically multivalue cells and display the same one below other and also i want the duplicate names also to be displayed