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.
Automating Harvey Balls based on RAG status
Could somoen please help with the formula I need to use to automate completion of Harvey Balls based on RAG status of four phases?
I am using RAG status balls (Green, Yellow, Red and Blue) to indicate status of each phase of the implementation. I have four implementation phases and basically want the Harvey Balls to Go from Quarter full when I have Blue RAG for phase 1, to Half full when I have Blue RAG for phase 2 etc. all the way to full when I have Blue RAG agains all four phases of my implementation (we chose Blue to denominate completion of the phase).
I tried to use the nested IF formual that you have on your Formula Example sheet but I keep getting an error :-(
Any help would be much appreciated.