Reveal after two selections

Lorne Andersen 241 Reputation points
2022-04-04T12:06:58.25+00:00

Hello - The first image (Brief type) shows three choices, where the second image (Funding) shows multiple. I would like the column (Pop Elements) to appear only when the choice 'New' is selected under Brief Type and when any of the other choices are selected under Funding.

I have tried the below, but have failed:

=if([$CUSTOMERNAME] == 'New', 'true','false'&&[$FUNDING]=='', 'true','false'
189732-image.png

189733-image.png

189705-image.png

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,061 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yi Lu_MSFT 17,271 Reputation points
    2022-04-05T15:01:02.837+00:00

    Hi @Lorne Andersen
    You could use the following code:

    =if([$CUSTOMERNAME] == 'New'&&[$FUNDING] !='', 'true', 'false')  
    

    As a result, when edit the item, Pop Elements will display only when CUSTOMERNAME] is 'New' and FUNDING is not blank:

    190294-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