Forum Discussion

wmendez27's avatar
wmendez27
Copper Contributor
Nov 17, 2024

Sharepoint List Help!!

I have one Column called 'QA Score'

This is what I want to do:

'QA score' needs to show the value of the column 'Call Review Average Score' if 'Call Review' is selected in 'Score Category'

'QA score' needs to show the value of the column 'Voicemail Review Total Score' if 'Voicemail Review' is selected in 'Score Category'

'QA score' needs to show the value of the column 'Gatekeeper Review Total Score' if 'Gatekeeper Review' is selected in 'Score Category'

'QA score' needs to show the value of the column 'No Call Review Total Score' if 'No Call Account Review' is selected in 'Score Category'

 

I used chat GPT to help me, and it gave me the following JSON formula:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField == 'Call Review', @row['Call Review Average Score'], if(@currentField == 'Voicemail Review', @row['Voicemail Review Total Score'], if(@currentField == 'Gatekeeper Review', @row['Gatekeeper Review Total Score'], if(@currentField == 'No Call Account Review', @row['No Call Review Total Score'], ''))))"
}

 

However, it kinda works, it shows me the content but as a formula, not as the result (See snap below):

 

 

 

  • Martin-Coupal's avatar
    Martin-Coupal
    Steel Contributor

    You need to create a calculated column QA Score where the formula will be something like =IF(ScoreCategory="Call Review",CallReviewAverageScore,IF(ScoreCategory="Voicemail Review",VoicemailReviewTotalScore,IF(ScoreCategory="Gatekeeper Review",GatekeeperReviewTotalScore,IF(ScoreCategory="No Call Account Review",NoCallReviewTotalScore,0))))

  • Martin-Coupal's avatar
    Martin-Coupal
    Steel Contributor

    If you don't find where to create a calculated column, you need to select "See all column types" when adding a new column.

     

     

Resources