Show Hide Columns in SharePoint list forms conditionally

In this Article, We will see how show hide a column from list or libary forms in SharePoint conditionally in SharePont online. By the term SharePoint list and library forms I means new and edit form of list or libary.

It was much awated feature from Microsoft and now it is very easy to show hide columns in new and edit forms in SharePoint List event conditionally. So lets have a look on it quickly.

 

First lets have a look on how to show hide a column in SharePoint and then we will see how to show or hide the column on the basis of a condition.

 

Show hide columns from SharePoint list

 In order to show hide columns from SharePoint list or libarary forms follow below steps.

1. Click on new form of list or libarary
2. On the new form, Click on Edit forms and then click on Edit columns as shown in image below

Conditionally show or hide columns from sharepoint list or library form

Now lets suppose we want to apply a condition to show or hide the form then follow then we can apply a conditional formula for that. lets see step by step on how to apply conditional formula to show or hide columns from new or edit form of list or libarary in SharePoint.

 

To complete the example, I have created a SharePoint list with below columns

1. Project (Single line of Text)
2. Cost (Number)
3. Approver (Person)

Lets suppose that we want to show the approvar field in new or edit form only when cost is greater than 500.

 

Below steps shows how to do this.

 

• Go to new form of SharePoint list
• Click on Edit form then Edit columns as per above image.
• Just next to the columns, click on ... to show the menu as shown in image below and then select "Edit conditional formula" as shown in image below

Paste below conditional formula

=if([$Cost]>500,'true','false')

Writing conditional formula

In this section, lets see how to write conditional formula.

 

We just need to remember below points.

1. To refer  to a field in the list, We need use [$FieldInternalName].
2. Formula should return true or false value only. use if condition, first argument is the condition and condition will evaluate to second argument if condition is true other wise third argument.
3. To compare person  type column, use some attrubute of person field like email  as below                                                                                                  

   =if([$PersonFieldInternalName].email=='abc@test.com','true','false')

  4. You can also compare DateTime fields just just Date function to convert string to date , for Example                                                                               

=if([$MyDateField]==Date('15/5/2020'),'true','false')

  5. You can also add / substract the value of fields before comparing, for example                                                                                                                           

=if([$MyField1]+[$MyField2]<500,'true','false')

                          

Supported field types for Conditional Formula

Not all field types in SharePoint Online lists are supported for conditional formulas. As of now the field types which are not supported are given below

1. Person column with multiple selection
2. DateTime column with time calculation
3. Currency columns
4. Location columns
5. Calculated columns
6. Managed Metadata columns