Trend Formula with R,Y,G balls

dtamayo

Good Morning Smartsheet friends, I am new to Smartsheet and have been working to learn as much as I can about this program. I'm trying to show my leadership the value in its usage. I'm trying to figure out a formula that will COUNT the number of weeks a R,Y,G ball is a specific color to show a trend. We track items by the week and I want to roll this up to the end where there is a column that counts the number of R,Y,G balls for each row. Does this make sense or does anyone have a better idea? Thank you!

Paul Newcome

You would have three separate columns (one for each color summary). Then you would use something like this...

=COUNTIFS([6 Jan 2021]@row:[7 Apr 2021]@row, @cell = "Green")

Just change the "Green" to the appropriate color for each of the two other colors in their respective summary columns, and you should be good to go.

Paul Newcome

You would have three separate columns (one for each color summary). Then you would use something like this...

=COUNTIFS([6 Jan 2021]@row:[7 Apr 2021]@row, @cell = "Green")

Just change the "Green" to the appropriate color for each of the two other colors in their respective summary columns, and you should be good to go.

dtamayo

Thank you @Paul Newcome I see you answer a ton of questions, it's great to hear from the best! Truly appreciate your assistance it worked like a charm!

Paul Newcome

Haha. Thank you, but I am certainly not the best. I am however, always happy to help. 👍️