MS Lists conditional questions that can make columns visible/hidden

az-sayl-emp-7411 25 Reputation points

I'm trying to make columns that can be visible/hidden upon condition.

The condition that I would like to implement is,

if Do you use any fuel for non-travel purposes? is 'Yes' then Mains Gas and Gas Oil should be shown if not then both should stay hidden


The condition that I implemented is


After saving it, the Mains Gas question is hidden whether or not Do you use fuel for any non-travel purposes? is answered.

now its gone

Can someone help me with this issue? Thank you.

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,891 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 16,876 Reputation points Microsoft Vendor

    Hi @az-sayl-emp-7411,

    You need to use the internal name of the column in you formula.

    How to fetch the internal name of a field from UI:

    Go to List settings >> Columns >> Click the column Do you use any fuel for non-travel purposes? >> See the internal name at the end of the URL(after ...Field=).

    For example(See the screenshot below), the internal name of the field I got from after Field= is Doyouuseanyfuelfornon_x002d_trav.

    User's image

    So, I should use this formula =if([$Doyouuseanyfuelfornon_x002d_trav]=='Yes', 'true', 'false') for the column Mains Gas and Gas Oil. This works perfectly for me. Go to check the internal name of your own and you will achieve what you want then.

    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.