Creating Sharepoint List column making it required based on another column's value

Question

Hi there! I'd like to get some help with microsoft lists. I have a column where one can choose from 5 options (not numbers but text). I would like to create another column which would be required based on this first column's value. Basically, I would like that if "Szegmens" (on the picture yellow) value is "Vállalati" then the columns marked with colour blue would not be required, but if "Szegmens" is in another value (e.g. "MASS"), then it would be required. I have tried =IF([Szegmens]="VÁLLALATI", [Születési idő]check=true,[Születési idő]check=false, but it didn't really work. Thanks for your help in advance. i

Answer 1

Hi @Krapicz Balazs Istvan ，

You want to realize that when the value of "Szegmens" is "Vállalati", the other three columns are not displayed.

Here are steps(Execute each column that needs to be hidden)：

1.In the Edit columns pane

2.Select the far right hand edge of the "Születési idő" column to display the options menu (...), select Edit conditional formula.

3.Enter formula:

=if([$Szegmens] == 'VÁLLALATI', 'false', 'true')

For more detail information:Show or hide columns in a list or library form

---

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.