SOLVED

Sharepoint issue .

Brass Contributor

I have a ‘closeout’ option in share point form. I want that close out option can be ‘Yes’ based on 2 condition . Condition 1::  If option P1 -True , Other 6 option - Q1, Q2,Q3, Q4,Q5,Q6 -Yes then ‘Close out’ =yes . Same way Condition 2 :: if Option P1:False , Approval:True then ‘ close out’ can be true . Any way to achieve 2 condition same column . 

4 Replies

@ganeshsanap - Any thought on this ?

@Bd2023-b 

 

Are you trying to create calculated column (non-editable) for "closeout"? If yes, please share the conditions in detail - example/screenshot of data might help.

 

Or you are just trying to set default value for closeout column on the form, which can be manually edited by users at any time? If yes, you will have to customize the list form using Power Apps (for SharePoint online) or custom JavaScript (for SharePoint on-premises classic experience).


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.

Spoiler
Spoiler
 

@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 .

best response confirmed by Bd2023-b (Brass Contributor)
Solution

@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:

  1. 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( , ).
  2. Use correct display name of your SharePoint columns in above formula.
  3. 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.

1 best response

Accepted Solutions
best response confirmed by Bd2023-b (Brass Contributor)
Solution

@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:

  1. 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( , ).
  2. Use correct display name of your SharePoint columns in above formula.
  3. 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.

View solution in original post