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!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
This Month-End Checklist below has the same countif formula in both rows. January totals 100% and February only 96%. What am I missing? This is the formula It's counting the check boxes.
©2024. All Rights Reserved Smartsheet Inc.