SharePoint List- Custom column to return text value based on choice selection

Question

Hi Team

I'm not sure if this is possible, but I want to create a custom column in a SP list to return a text value of "External Changes" if two choice columns don't have the word "Merchant Services" in them. If both columns have the value of "Merchant Services", then return the value of "Internal MS Change"

The column names are:

-Portfolio

-Originating Business Unit/Domain

I'm thinking an if condition could meet this requirement and I'm hoping someone can provide me with the coding so I can create this custom column

Kind Regards

Harry

Answer 1

Here're steps:

1.Create a calculated column.

2.Use following formula in the calculated column.

=If(AND([Portfolio] = "Merchant Services", [Originating Business Unit/Domain] = "Merchant Services"), "Internal MS Change", "External Changes")

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.