-
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…
-
I have a column formula applied to a Status Column, however it is not applying to one of the rows.
The column formula is: =IF(Progress@row = "Complete", "Blue", IF(Progress@row = "Upcoming", "Green", IF(Progress@row = "Ongoing", "Green", IF(Progress@row = "Commenced", "Green", IF(Progress@row = "On Hold", "Yellow", IF(Progress@row = "Discontinued", "Red", IF(Progress@row = ".", "", IF(COUNTIF(CHILDREN(), "Blue") =…
-
Is there a way to capture seconds in the last edited column?
I would like to get the last edited timestamp column as mm/dd/yy hh:mm:ss.ss as opposed to the standard mm/dd/yy hh:mm. For example I would like 08/13/24 13:53:47.89 instead of the normal way that smart sheets rounds numbers to the nearest minute.
