Reveal on either selection and on another

Lorne Andersen 241 Reputation points
2022-04-19T12:35:12.617+00:00

Hi.

There are three columns: Brief Type, Estimating Requirement and Production Quote Date Required within a SharePoint list form.
When a user selects either 'New' or 'Revision' under Brief Type and 'Yes, submit' is selected under the Estimating Requirement, the column Production Quote Date Required must appear.

This code has been used but does not do what is required: =if([$CUSTOMERNAME]=='New'||[$CUSTOMERNAME]=='Revision'&&[$Requirement_x0020__x0028_6_x0029]=='Yes, submit','true','false')

Please can you help me with the correct code?

Thank-you.

194296-image.png194333-image.png

194295-image.png

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,009 questions
{count} votes

Accepted answer
  1. Emily Du-MSFT 43,176 Reputation points Microsoft Vendor
    2022-04-20T03:45:39.12+00:00

    @Lorne Andersen

    Please use following formula in the condition.

    =if([$EstimatingRequirement]=='Yes, submit'&&[$BriefType]=='New'||[$EstimatingRequirement]=='Yes, submit'&&[$BriefType]=='Revision', true, false)


    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 comments No comments

0 additional answers

Sort by: Most helpful