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!
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
Hi, I’m using Smartsheet with a Master Sheet(All over Projects Basic Summary) and Individual project sheets that have multiple phases. When I change the Assigned Person in the Master Sheet, I want: •It to update only phases that are Not Started or In Progress •It should not change phases that are Completed Is this…
I am working on a column formula that won't generate a syntax error due to the first-row data entries. The goal of this sheet is to document and calculate changes in counts from a one month to another. A form will be used for data entry, and I have the form set up to put new entries at the bottom. The formula in the…
