Microsoft Lists: How to hide columns in a new form using conditional formula

Microsoft Lists: How to hide columns in a new form using conditional formula

Introduction

While using Microsoft Lists, I encountered a situation where I wanted to hide specific columns in a new form.

New form with no hidden Answer column

I resolved this issue using the following approach.

Solution

I used a conditional formula to hide columns in a new form. Here are the steps and the formula I used:

  1. Open the form

  2. At the top of the form, select Edit form > Edit columns

  3. Check the columns you want to hide on the new form

  4. Select options menu (︙) > Edit conditional formula

  5. Set the following expression in the conditional formula:

    =if([$ID],'true','false')
    
  6. Select Save

    Steps to set the conditional formula

This completes the setup. The column with the conditional formula will now be hidden in the new form.

Comparison of new form, edit form, and disp form