-
Update to Is Not Blank Formula?
How do I make this formula operate the way I need to. If there isn't a due date or a status, I don't want it to get flagged as at risk yet. =IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, IF(AND(Status@row <> "Completed", [Due Date]@row - TODAY() <= 3, [Due Date]@row - TODAY() >= 0), 1, 0))
-
Formula Help: Risk Flag based on End Date
Can someone help me create a formula based on end date If EndDate is <TODAY and Status Does Not Equal "completed" Red Flag in Risk Column TIA
-
Multiple Deadline/Due Date columns for each project (row) - Combined Report
I have a sheet used to track grant deadlines, and there are multiple deadline columns for each grant (application deadline, report 1 deadline, report 2 deadline, etc. - example below). I am looking to create a report or even a sheet that pulls in a grant and each respective deadline that occurs in the next 120 days. My…
-
Display dates differently on a dashboard
I work in a global organization, and I prefer to plan my dates in 1/20/24 format but with our European partners that can get confusing. So when sharing dates with them we display as Jan 20, 24. However, I'm tracking and mapping dates against a lot of other North America teams who plan in 1/20/24 so it's easier for me to…
-
Sum the rest of a column
Hi All, I am trying to sum the rest of a column (see below). This is in the creation of a a blueprint workspace, so there is no data in there and so please ignore the divide by zero errors. I have 2 sections for project costs, one for labour costs which is based on a very simple salary*timeframe formula, and then a second…
-
If, then Formulas
Hi there! I am trying to create a formula for the following scenario and i've been unable to figure it out If Status Column is "Complete", Mark as Green, IF Status of Column is NOT Complete, then apply the formula =IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row >…
-
Auto Save / Invalid Operations Error.
Hi All, I have been searching community forum to this unsaved issue that I am having with my PMO but no luck so far and appreciate if someone could help me with this. According to what I have observed, the tasks sheet is not getting saved due to which some of the columns on Portfolio / Project Tracking Dashboard (Schedule…
-
Symbols and Formulas
I am trying to create a formula that will give a column a symbol (red, green, yellow blue) based off of the amounts of colored symbols in the column. Right now in each row, I have associated a symbol based on the task status - the symbols are Red/Yellow/Green/Blue I want to be able to assign an overall Symbol for the…
-
#Unparseable - AVG if business unit and current year.
Hi all. In a sheet summary field I'm looking to get the average number of days, if the year is current and for a particular business unit. Iterations on the following result in #Unparseable of #Incorrect Argument? where am I going wrong? =AVERAGEIFS([Time in application (Days)]:[Time in application (Days)], [Date…
-
Process Identifier Automation
Hi, I have a formula that should be identifying the next number and adding a number to it based on the next number. What I am struggling with, it is repeating numbers and I cannot get it to stop. [Row ID] is an autonumber [Process Type] is a dropdown with PP - Parent Process SP - Sub-Process 3P - Third Party CA - Critical…