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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!