I have two YES/NO Columns, that if either of them has a YES then its a failure and my caluclated column will say pass or Fail. =IF([Observation Required]="Yes",IF([NCR Required]="Yes","Fail","Pass")) This just returns a value of "No" in each row.

jamescosten the formula isn't quite correct, use this instead:=IF(OR([Observation Required]=TRUE,[NCR Required]=TRUE),"Fail","Pass") RobLos GallardosMicrosoft Power Automate Community Super User.Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Calulated COlumn Double If Function | Microsoft Community Hub

Rob_Elliott
Bronze Contributor
Feb 13, 2024
jamescosten the formula isn't quite correct, use this instead:

=IF(OR([Observation Required]=TRUE,[NCR Required]=TRUE),"Fail","Pass")

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
- jamescosten
  Brass Contributor
  Feb 14, 2024
  Thank you very much
  - ganeshsanap
    MVP
    Feb 14, 2024
    jamescosten Here is a shorter version of same formula (as Yes/No columns return TRUE/FALSE by default):
    
    =IF(OR([Observation Required],[NCR Required]),"Fail","Pass")
    
    Output:
    
    Note:
    
    Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
    
    Use correct display name of your SharePoint columns in above formula.
    
    Wrap column names inside [] if your column name has space in it. For example: [My Column Name].
    
    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Forum Discussion

Calulated COlumn Double If Function