question

DoraYeh-2155 avatar image
0 Votes"
DoraYeh-2155 asked saldana-msft edited

Sharepoint : Show or hide columns in a list or library form with or operater

Hi, there

I want to do conditional formula , in my case, Category has five option: Apple, Banana , Orange , Mango, Peach.
When select Apple, Banana, Orange , another input is shown.

How to do that ,please tell me, thanks.


Best regards,
Dora.

office-sharepoint-onlinesharepoint-devmicrosoft-graph-sites-lists
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @dorayeh-2155 ,

This is a quick note to let you know that we are performing research on this issue.

Thanks,
Echo Du

0 Votes 0 ·

1 Answer

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT commented

Hi @dorayeh-2155 ,

Please follow the steps:

1.In my test, I have a Choice column named [Category] and a Single line of text column named [Format]

164907-f1.jpg

2.You can choose to hide [Format] on view

164928-f2.jpg

3.On the "Edit columns in the form" panel, select [Format] (the field that you want to hide) and click Edit conditional formula

164973-f3.jpg

4.Use the below formula:

 =if([$Category] == 'Apple' || [$Category] == 'Banana' || [$Category] == 'Orange', 'true', 'false')

164929-f4.jpg

5.The [Format] only appears on the Edit Form when you select "Apple" or "Banana" or "Orange"

164974-hide-column.gif

Thanks,
Echo Du
==================================
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.




f1.jpg (88.6 KiB)
f2.jpg (87.0 KiB)
f3.jpg (81.5 KiB)
f4.jpg (70.5 KiB)
hide-column.gif (1.8 MiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @dorayeh-2155 ,

I'm glad I can help you solve the problem. Looking forward to our next cooperation.

Thanks,
Echo Du

0 Votes 0 ·