-
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
-
Add Values to Each Dropdown Value
Hello, We have a Supplier Dropdown with the name of each of our suppliers. I would like to create a formula that takes each of those values and goes out to another table (Supplier Directory) and returns the City, State, and Country of each of those suppliers. I have the following formulas that look up the city, state,…
-
Based on frequency selected change the formula for the created date.
I feel like this should be super simple but I am just not getting it right. Based on Frequency: Daily, weekly, monthly I want to change the next due date This will be calulated from Created column and +1, 7, 30 etc added. It works single instance =IF(Frequency@row = "Daily", Created@row + 1) but as soon as I try to write…