SharePoint 2019 Conditional Formatting Json Custom List

%3CLINGO-SUB%20id%3D%22lingo-sub-1226850%22%20slang%3D%22en-US%22%3ESharePoint%202019%20Conditional%20Formatting%20Json%20Custom%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1226850%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3ESharePoint%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EConditional%20Formatting%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20Kitemarking%20system%20has%20a%20maximum%20of%20a%20five%20star%20rating%20which%20is%20based%20on%20the%20following%3A%3C%2FP%3E%3CUL%3E%3CLI%3EWell%20Defined%20Data%20Definition%20(Question%203%20and%204%20Has%20a%20data%20value)%3C%2FLI%3E%3CLI%3EData%20warehouse%20(Question%205%20has%20a%20data%20value)%3C%2FLI%3E%3CLI%3ETechnical%20Data%20Definition%20Agreed%20(Question%206%20has%20a%20data%20value)%3C%2FLI%3E%3CLI%3EFull%20Accuracy%20and%20Assurance%20Signed%20Off%20(Q14%20%26amp%3B%2015)%3C%2FLI%3E%3CLI%3EData%20has%20been%20signed%20off%20by%20the%20responsible%20executive%20(Q12%20and%26nbsp%3B%20Q14%20are%20not%20blank)%3C%2FLI%3E%3C%2FUL%3E%3CP%3EEach%20bullet%20above%20equates%20to%20a%20star%20for%20example%20to%20get%20a%205%20star%20rating%20all%20items%20are%20required.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20in%20practice%20the%20single%20column%20called%20Star%20Rating%20could%20contain%201%20-%205%20Asterix(s)%20depending%20on%20each%20of%20the%208%20columns%20containing%20a%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20a%20Json%20script%20that%20would%20solve%20with%20this%20requirement%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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