Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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!
Hi everyone! I have a list of report dates that I want to be notified on, but am having trouble getting this set up. My thought process was to create a column with =TODAY() in the first cell, and then set up automations to be alerted when "Today" equals the "Report Date". My issue is that two are different formats. The…
Currently below is what Smartsheet allows for Group management. In our organization, this is very restrictive as it only allows 3 people to manage groups that required a lot of maintenance. Allows Group Admins this ability would make it much more flexible for large organizations who have multiple individuals with the…
Hi All i am trying to determine the stage that a project should have readhed by today, based on a series of milestone dates across the row however, in this particular example i am getting #invalid operation which may be due to the blanks. they are blanks because they currently have no date which is probably a flaw in the…
