Visible If statements with multiple choice

(1) Share

Report

Posted on by cwyn_ah

Hi everyone,

I am hoping this is an easy fix, so any help is appreciated :)

I have an Edit Form (formCoffee), that has a bunch of datacards connected via SharePoint. I have specific datacards that I want visible/invisible based on what 'Location' option is selected in a multiple-choice dropdown datacard I have setup. This is the closest I have gotten as an example:

I am wanting the below code to make said datacard only visible if 1 of these 3 locations are selected. Currently it only makes visible 'Headquarters', I assume because it's the first one listed. How can I write this, so it is visible when any of these are selected?

If(DataCardValue96.Selected.Value="Headquarters", true ,"Solutions", true ,"Southwoods", true )

Categories:

Error handling

I have the same question (0)

All responses (2)

Answers (0)

Sort by

cwyn_ah 22 on at

Like (1)

Report
Copy link

Link copied!
UPDATE:

I just figured it out hours later haha, here was my solution:

If(Or(DataCardValue96.Selected.Value="Headquarters",DataCardValue96.Selected.Value="Solutions",DataCardValue96.Selected.Value="Southwoods"), true , false )

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi there, feels good when you find the solution, right? :)

you can make the solution simpler this way -

DataCardValue96.Selected.Value="Headquarters" || DataCardValue96.Selected.Value="Solutions" || DataCardValue96.Selected.Value="Southwoods"

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No