-
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",ā¦
-
Projects releasing today + 60 days
Hi all, I have a formula such: =COUNTIF({project rel +2mos}, >=TODAY(+60)) that is returning a 0 count, even though there should be a count there. I do have the specified column I'm calling set to "Date". Any help greatly appreciated!
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if theā¦