Hi,
I am using this formula in a dots column (red, yellow, green).
We are measuring completion for training. There is a 5-hour training and a 25-hour training. Originally, the 5-hour had to be completed by the end of August but apparently that didn't happen. So we had it set up that if 5-hour AND 25-hour is complete, it would be green. If 5-hour only was completed, it would be yellow. And if no training was completed, it would be red.
Now, they have told me that some people who have done 25-hour training have NOT completed the 5-hour training, so that needs yet another color. Originally, no one who finished 25-hour would have not first done 5-hour but that hasn't happened. So, they need to know who has completed 25-hour but not 5-hour.
Current formula:
=IF([25-Hour Training Complete]@row = "", IF([5-Hour Training Complete]@row = "", "Red", "Yellow"), "Green")
If I wanted Grey to represent people who have finished 25-hour training but not 5-hour, how would I work that into this formula? Thank you to whoever can help.
