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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!