In Share Point I am using =IF( OR( and unable to save the formula.

Question

In Share Point I am using =IF( OR( and unable to save the formula.

Sachin Sadalage 0

In Share Point I have a 'Review Type' choice column.
In Share Point I have a '% of NF errors' calculated column.

I want to show percentage only when 'Review Type' is selected as 'QA Audit', 'Escalation', 'TL audit'

and I am using formula
=IF (

OR ([Review type] ="QA Audit",

[Review type] ="Escalation",

[Review type] ="TL audit"),

[Total no of Non-Fatal]/ [Number of items checked],

""

**)

**Unable to save this formula and getting error as Sorry, something went wrong
My other column formulas are working correctly.

Please check this and suggest.

Ruby Nguyen 2,050 Reputation points Independent Advisor

2026-09-16T14:14:23.2066667+00:00

Hi Sachin,

I hope you're having a good week.

I'm just checking in to see if there have been any updates on the issue. I hope things are moving in the right direction and that a resolution is near.

Whenever you have an update, I'd be grateful if you could let me know.

Thanks again for your time.

1 answer

Your answer

Ruby Nguyen 2,050 Reputation points Independent Advisor

2026-09-16T14:14:23.2066667+00:00

Hi Sachin,

I hope you're having a good week.

I'm just checking in to see if there have been any updates on the issue. I hope things are moving in the right direction and that a resolution is near.

Whenever you have an update, I'd be grateful if you could let me know.

Thanks again for your time.

Answer 1

Good day Sachin,

I understand that you want the % of NF errors column to calculate a value only when Review Type is QA Audit, Escalation, or TL audit.

Please start with these steps:

Please note that I created and tested these formulas in a lab environment based on the information provided. Since SharePoint configurations, column settings and list structures can vary between environments, the formulas may work successfully in my test environment but behave differently in yours.

Open your SharePoint list and go to List Settings.

Select the % of NF errors calculated column.

Remove the current formula.

Enter the formula below as a single line:

=IF(OR([Review Type]="QA Audit",[Review Type]="Escalation",[Review Type]="TL audit"),[Total no of Non-Fatal]/[Number of items checked],"")

Set The data type returned from this formula to Number.

Format the result as Percentage and save the column.

User's image

If the formula still doesn't save, use the nested IF version instead:

=IF([Review Type]="QA Audit",[Total no of Non-Fatal]/[Number of items checked],IF([Review Type]="Escalation",[Total no of Non-Fatal]/[Number of items checked],IF([Review Type]="TL audit",[Total no of Non-Fatal]/[Number of items checked],"")))

Please also verify the following:

Review Type is a single choice column.

The column names in the formula exactly match the column display names in the list.

Total no of Non-Fatal and Number of items checked are numeric columns.

The formula is pasted without any extra formatting or special characters.

This should help identify whether the issue is related to the formula syntax, column configuration, or column naming.

If you have any questions or need further support, please don’t hesitate to reach out at any time.

Thank you for your patience and understanding.

If you have any extra questions about this answer, please click "Comment".