Forum Discussion
Calulated COlumn Double If Function
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")Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
3 Replies
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)- Thank you very much
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.
