CODEWITHSUNDEEP
sharepointconditional-formatting
Ed Goh
Ed Goh

Reputation: 11

Sharepoint - How can I conditionally show a column OR hide a column based on selected value from another column?

I am having trouble to conditionally format a column to be shown as mandatory/ option or hidden based on value from another column in sharepoint.

For example:

Column 1 = Facebook/ Twitter/ Instagram

Column 2 = Yes/ No

Using the example above - I've tried the formula =if([$Column1] == 'Instagram', 'true', 'false'). However, this will show column 2 as optional if selected value for column 1 is Facebook/ Twitter.

I've also tried to configure column 2 as mandatory from column setting. However, once column 2 is mandatory, then I won't be able to insert any condition formula for column 2.

Can you please assist?

Thanks in advance

Upvotes: 1

Views: 1425

Answers (1)

Ganesh Sanap - MVP
Ganesh Sanap - MVP

Reputation: 2228

You cannot make a column Mandatory/Optional using conditional formula in SharePoint.

You can only show or hide columns in a list forms using conditional formula.

Also, if you make a column as required field from column settings, you cannot add conditional formula on it. This is by design

Documentation: Show or hide columns in a list or library form

You can make columns mandatory/optional by customizing the list forms using Power Apps.

For more information, check:

  1. Make a field required based on another field
  2. How do you make a field required?

Upvotes: 1

Related Questions