Trend Formula with R,Y,G balls
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!
Best Answer
-
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.
Answers
-
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.
-
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!
-
Haha. Thank you, but I am certainly not the best. I am however, always happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!