Sign in to join the conversation:
hello,
i am looking to find a way to do an average with the RYG balls.
ex: 2 green, 2 yellow, 2 red should have should show yellow ball for the overall project.
is this something possible?
thanks for your help
I can't help you with the method, but can I offer some thoughts?
When rolling up status (which isn't a great plan anyway), I always use the worse indicator rather than average.
e.g. if your project has 1 red indicator, it overrides 999 greens or yellows and I'd be reporting the overall status as red because you have an activity which isn't going to make it.
May be better to report on the number of reds, yellows and greens separately?
Not sure what metrics you are using or how you have defined RYG so happy to wind-my-neck-in if necessary!
I need a column formula that can add sequential, unique IDs to data like this coming in from a form: Task Type Task ID Manual M001 Automated Manual M002 Manual M003 Manual M004 Automated Manual M005 Task IDs that aren’t the manual type need sequential numbering within their type (i.e. A001, A002, etc). Here’s the kicker:…
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
Hi everyone. We have an upcoming project is very short, but very critical, and requires that we track not only the start and end dates, but also the start and end times. Currently our team has added two columns, start time & end time, and they would like to add a duration column that can track the planned duration in…
