Hi, would anyone be able to help me out here. I am trying to automate some KPIs and I want to return a RAG based on the value column. Depending on whether the value falls into Gold, Green, Amber, or Red - I want to return that in the RAG column. The only problem is that I have other symbols in those columns. Attached is a screenshot .
Do you need to specifically reference those columns, or could you not just build the logic into some formula tools like below:
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |