Calculating Percentage in "Administrative Column")

Good day Smarters,

Any help would be appreciated.

I have three columns

  1. Status Column with Symbols: RED, Green and Yellow
  2. Category of Staff column which is a drop down, one of which is Administrative Staff among others
  3. Administrative Staff Column (fixed) to indicate my calculation(%) below

Question: How do I create a formula to reflect the % of Administrative Staff which are Green and Yellow? i.e (Green + Yellow)/ (Green + Yellow + Red).

Thanks in advance

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!