Hi guys, I need some help with the condition option to create a mandate field in SharePoint.

Anonymous
2022-03-15T12:40:22.053+00:00

Hi guys, I need some help with the condition option to create a mandate field in SharePoint.

Considering columns A Opportunity Stage , columns B Contract Execution Date
I need to make mandate filed column B with the following logic:

If we select Opportunity Stage as Closed (Multiple choice), then Contract Execution Date should become mandate to fill, else optional.

Thanks in advance

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,221 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,668 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,573 questions
0 comments
Accepted answer
  1. JoyZ 18,041 Reputation points
    2022-03-16T05:22:20.93+00:00

    @Anonymous ,

    To meet your requirement, make sure the choice column "Opportunity Stage" has single selection, then go to list settings>validation settings under General Settings>Set formula something like: 

    =IF([Opportunity Stage]="Closed",IF(ISBLANK([Contract Execution Date]),FALSE,TRUE),TRUE)

    183514-image.png
    Result for your reference:

    183503-image.png

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest