Forum Discussion

Bd2023-b's avatar
Bd2023-b
Brass Contributor
Sep 09, 2023
Solved

Sharepoint issue .

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 ‘Cl...
developer
sharepoint server
  • ganeshsanap's avatar
    ganeshsanap
    Sep 11, 2023

    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.

Resources