Forum Discussion
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 sco...
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))))