I was trying to make a label's visibility false if my multiple choice column "BidStatus" value contained finalizing, create quote, or funding value. However it doesnt not seem to work using this code:
If(SelectedTicket.BidStatus.Value = "Finalizing" || "Create Quote" || "Funding", false ,true)
Is there another way I should be coding or looking at this?
Thanks for the help!
Solved! Go to Solution.
Unfortunately, you need to write this code out in full, ie
If(
SelectedTicket.BidStatus.Value = "Finalizing" ||
SelectedTicket.BidStatus.Value = "Create Quote" ||
SelectedTicket.BidStatus.Value = "Funding",
false,
true
)
Unfortunately, you need to write this code out in full, ie
If(
SelectedTicket.BidStatus.Value = "Finalizing" ||
SelectedTicket.BidStatus.Value = "Create Quote" ||
SelectedTicket.BidStatus.Value = "Funding",
false,
true
)
Hi @Leu0101 ,
Since it is a choices column that allows multiple selection, the selected values are actually in a table. As per your goal, you will need to change the formula to:
If( "Finalizing" in SelectedTicket.BidStatus.Value || "Create Quote" in SelectedTicket.BidStatus.Value || "Funding" in SelectedTicket.BidStatus.Value , false ,true)
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Thanks for the information! Good to know!