Hi all,

I’m breaking my head over this for a couple of days now.

I have this sharepoint list I want to use to keep an overview of all the employees and their qualifications. Every time someone gets trained for something we create an item with the information on wich qualification they were trained on and if they are now qualified to perform set tasks (via MS forms).

I want to create a view that shows me Who is Qualified for wich Qualification.

I tried some things with grouping on Qualification and Person. Used some JSON samples to make it easier to look at and voila. There is just one thing i can’t seem to get to work.

I want the group headers of Person to have conditional formatting based on the value in the Qualified  column in the first item in the group. 

As of right now I have to manualy click on every person to see if they are Qualified or not. I could filter to only have qualified persons in my list but I want to know if someone has lost their qualification.

So i want to see them as well.

I tried some If-statements but everytime i tried to refer to the Qualified column (yes i used the internal name) it showed no values.

Possibly because the view is trying to find a value in the Qualified column where the group headers are, but i’m not sure.

In this example I need “Carles Xavier” to have a red background color (because he is not Qualified to Drive) And “James Wyatt” to have a green background color.

ChatGPT said it is impossible but i’m stubborn so i will try posting this here.

If you need more information please let me know.

thanks in advance,

Mike

​Hi all, I’m breaking my head over this for a couple of days now.I have this sharepoint list I want to use to keep an overview of all the employees and their qualifications. Every time someone gets trained for something we create an item with the information on wich qualification they were trained on and if they are now qualified to perform set tasks (via MS forms). I want to create a view that shows me Who is Qualified for wich Qualification.I tried some things with grouping on Qualification and Person. Used some JSON samples to make it easier to look at and voila. There is just one thing i can’t seem to get to work. I want the group headers of Person to have conditional formatting based on the value in the Qualified  column in the first item in the group. As of right now I have to manualy click on every person to see if they are Qualified or not. I could filter to only have qualified persons in my list but I want to know if someone has lost their qualification.So i want to see them as well. I tried some If-statements but everytime i tried to refer to the Qualified column (yes i used the internal name) it showed no values.Possibly because the view is trying to find a value in the Qualified column where the group headers are, but i’m not sure.  In this example I need “Carles Xavier” to have a red background color (because he is not Qualified to Drive) And “James Wyatt” to have a green background color. ChatGPT said it is impossible but i’m stubborn so i will try posting this here. If you need more information please let me know. thanks in advance, Mike   Read More

​