Forum Discussion
Sharepoint issue .
Bd2023-b What is the data type of all these columns, choice columns for Yes/No (Boolean) columns?
If those are Yes/No (Boolean) columns, you can use formula like:
=OR(AND([P1],[Q1],[Q2],[Q3],[Q4],[Q5],[Q6]),AND(NOT([P1]),[Approval]))If those are choice columns, you can use formula like:
=IF(OR(AND([P1]="True",[Q1]="Yes",[Q2]="Yes",[Q3]="Yes",[Q4]="Yes",[Q5]="Yes",[Q6]="Yes"),AND([P1]="False",[Approval]="True")),"Yes","No")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.
ganeshsanap - Close out will be a calculated column . But it will be drive by 2 condition as mentioned above. Condition 1:: If radio button P1 -True , Other 6 radio button : Q1, Q2,Q3, Q4,Q5,Q6 -Yes then ‘Close out’ will be yes . Same way Condition 2 :: if Radio button P1:False , other radio button Approval:True then ‘ close out’ can be true .
Bd2023-b What is the data type of all these columns, choice columns for Yes/No (Boolean) columns?
If those are Yes/No (Boolean) columns, you can use formula like:
=OR(AND([P1],[Q1],[Q2],[Q3],[Q4],[Q5],[Q6]),AND(NOT([P1]),[Approval]))
If those are choice columns, you can use formula like:
=IF(OR(AND([P1]="True",[Q1]="Yes",[Q2]="Yes",[Q3]="Yes",[Q4]="Yes",[Q5]="Yes",[Q6]="Yes"),AND([P1]="False",[Approval]="True")),"Yes","No")
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.
