Forum Discussion
Conditional column - Find text - Award points
I want to use a conditional column in a SharePoint list to check the column “ET-07” for the following text content:
[“Symptoms are visible signs, causes are the real reasons for a problem.”, “A symptom is the effect, a cause is the reason for a problem.”].
The square brackets and quotation marks belong to the text in column “ET-07”.
With the help of ChatGPT I have tried various solutions. Setting the text without square brackets and quotation marks was also unsuccessful. A syntax error is always detected.
For the column “ET-06” where there is only one string, the following approach works:
=IF([ET-06] = “The 8D method is a process for systematic problem solving in 8 steps”, 1, 0)
Ideally, I would want to check column ET-07 to see whether, for example, only string 1 or string 2 is present, or both, or neither. Numbers 0,1,2 are then set according to their presence. The following approach did not work:
=IF(AND([ET-07] = “A manager takes responsibility for preventing and correcting errors.”, [ET-07] = “Managers are responsible for preventing and correcting errors in the team.”), 2, IF(OR([ET-07] = “A manager takes responsibility for preventing and correcting errors.”, [ET-07] = “Managers are responsible for preventing and correcting errors in the team.”), 1, 0))
I hope someone can help me. The spelling of the strings with [” ”] comes from the submission of an MS Forms quiz.