SharePoint 2019 Conditional Formatting Json Custom List

Occasional Visitor

SharePoint  Conditional Formatting


A Kitemarking system has a maximum of a five star rating which is based on the following:

  • Well Defined Data Definition (Question 3 and 4 Has a data value)
  • Data warehouse (Question 5 has a data value)
  • Technical Data Definition Agreed (Question 6 has a data value)
  • Full Accuracy and Assurance Signed Off (Q14 & 15)
  • Data has been signed off by the responsible executive (Q12 and  Q14 are not blank)

Each bullet above equates to a star for example to get a 5 star rating all items are required.


So in practice the single column called Star Rating could contain 1 - 5 Asterix(s) depending on each of the 8 columns containing a value.


Can anyone help with a Json script that would solve with this requirement?

0 Replies