List column logic for conditional text values

Question

I want to create a column in a SharePoint list that returns the text value "External changes" if two choice columns do not contain the phrase "Supplier Services". However, if both columns do have the value "Supplier Services" the column should return "Internal changes".

I'm thinking an if condition could meet this requirement and I'm hoping someone can provide me with the help.

Answer 1

Here're steps:

1.Create a calculated column.

2.Use following formula in the calculated column.

=IF(AND(choicecolumn1="Supplier Services",choicecolumn2="Supplier Services"),"Internal changes",IF(AND(choicecolumn1<>"Supplier Services",choicecolumn2<>"Supplier Services"),"External changes","others"))

3.Result.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.