Sep 08 2023 08:18 PM
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 .
Sep 09 2023 11:21 PM
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.
Sep 10 2023 05:06 AM - edited Sep 10 2023 05:10 AM
@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 .
Sep 10 2023 09:02 PM - edited Sep 10 2023 09:04 PM
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:
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.
Sep 10 2023 09:02 PM - edited Sep 10 2023 09:04 PM
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:
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.