-
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…
-
Need help with Index formula across sheets
I have a Master sheet that I would like to source information to subsheets for Project columns, of which then the % complete and date complete on each subsheet gets Indexed back to the Master sheet. However, I am needing to add 2 lines on the Master sheet to populate on all of the subsheets, but when I assign them unique…
-
CONTAINS FORMULA WITHIN A DATE RANGE
Hello, I'm trying to create a formula to count / sum the number of times a cell contains some txt within a date / year range. The formula works for regular cells which contain only one piece of txt. However I'm trying to count from a cell which has multiple entries. I'm sure this is an easy one. Can anyone help please?…
-
Help to link health status formula to status
Hi, Need some help here is my current formula for health status in project plan. =IF([End Date]@row = "", "", IF([Summary Helper]@row = 1, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", ""))), IF(Status@row = "Complete", "Blue",…