Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counting Total Number Correct of RYG Balls per person

edited 12/09/19 in Archived 2017 Posts


Can anyone help me with my a formula that will allow you to count the "Green RYG balls" which means completed for our purposes.  I am trying to count the number of completed "Green" RYG balls, per person in order to use on the dashboard I am creating.  

I trying to display how many tasks has "John Doe" completed and I only want the total number to display, of completed by John.  I don't need a report I just in a total number for each person.


This discussion has been closed.