Forum Discussion

neeesz78's avatar
neeesz78
Copper Contributor
Nov 17, 2021

LIST Column Formatting - using Jason

Hello All, 

 

I have a Risk_Value Column on my SharePoint List , the Risk value column --> will only hold 1 unique value from the 49 possible values as per the below 7*7 matrix 

 

Q: is there a way to format risk-value column to display color & text based on the following

  • if  Risk_value is any of blue cells (blue , level 4)
  • if Risk_value is within any yellow cells (Yellow , level 3) 
  • if Risk_value is within any orange cells (Orange , level 2) .
  • .............etc.

 

3 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    neeesz78 I responded to a similar question here. Not sure if it will help you but come back with any questions.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • neeesz78's avatar
      neeesz78
      Copper Contributor
      RobElliott thanks for your help , I wanted to check if its possible to achieve this thru column formatting using Jason ?
      instead of customizing the Default SharePoint Edit Form
      • RobElliott's avatar
        RobElliott
        Silver Contributor

        neeesz78 possibly, but it would probably be an immensely complex JSON if statement and my day job doesn't give me the spare time to get my head round that!

         

        Rob
        Los Gallardos
        Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources