Forum Discussion

Livearus's avatar
Livearus
Copper Contributor
Feb 04, 2025

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.

No RepliesBe the first to reply

Resources