RYG green balls counting weekly


Could someone please provide a formula to count Green symbols in STATUS column during the past week? I need weekly report of how many green we get during past week . Also should I create special column for counting or I can use existing STATUS column.

Thanks in advance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!