SharePoint List conditional formula "if" "Or"

Question

SharePoint List conditional formula "if" "Or"

Muki 76

In the [$IncidentType] selection box i have the following selections

"privacy"
"Compliance"
"Consult"
"Audit"

and the form works correctly to hide / show fields. What i'm wondering is can the formula be adjusted so that the if the user selects "privacy" or "consult" that the field will show or hide.

=if([$IncidentType] == 'Privacy', 'true', 'false')

Accepted answer

2 additional answers

Your answer

Answer 1

Yi Lu_MSFT 17,616

Hi @Muki
You could use the following conditional formula:

=if([$IncidentType] == 'Privacy'||[$IncidentType] == 'Consult', 'true', 'false')

As a result, when the field in "IncidentType" column, the conditional column will be shown, otherwise will not.

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.

Christine Padberg 0 Reputation points

2023-03-15T20:49:17.65+00:00

Your reply was so helpful!

I am looking to do the same thing except with three conditions. I want the PRIORITY column to be shown only if the STATUS column is equal to Being Updated, or New Development < 50%, or New Development > 50%.

Using your sample, I wrote this:

=if([$STATUS] == 'Being Updated'||[$STATUS] == 'New Development < 50%'||[$STATUS] == 'New Development > 50%', 'true', 'false')

It did not generate an error message and I was able to save it, but the formatting is not working. The conditional column (PRIORITY) is hidden for all selected statuses.

Any thoughts on what I'm doing wrong?
Elisha Hollandbeck 0 Reputation points

2023-09-20T14:39:33.39+00:00

I was searching and searching for an IF OR formula that would work in SharePoint, and this worked for me. THANK YOU!

Christine - I had the same issue, and it was due to the column being required. I had to undo any requirements on the columns first and then enter the conditional formatting. Once I knew everything was working correctly, I reset my requirements.

Answer 2

Muki 76

AWESOME! it worked!

Answer 3

Hi @Yi Lu_MSFT !

I have a question I hope you have the solution. I created a SharePoint list with a multi-choice field called "Equipo" that can take several values at the same time. I have tried the following:

"background-color": "=if([$Equipo]=='FA','#FFF3D6',if([$Equipo]=='GC','#DEF7EB','#E7E7EE'))"

It worked when "Equipo" was a Choice field. However, I needed this field to be multi-choice, and now it is not working. I would like that if Equipo has one option, card looks with a particular color. Otherwise (several options selected), in white.

Where is the issue?

Thanks in advance

Share via

SharePoint List conditional formula "if" "Or"

2 additional answers

Your answer