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.
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.
Hi @dorayeh-2155 ,
This is a quick note to let you know that we are performing research on this issue.
Thanks,
Echo Du
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]

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

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

4.Use the below formula:
=if([$Category] == 'Apple' || [$Category] == 'Banana' || [$Category] == 'Orange', 'true', 'false')

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

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.
Hi @dorayeh-2155 ,
I'm glad I can help you solve the problem. Looking forward to our next cooperation.
Thanks,
Echo Du
10 people are following this question.