MS Lists conditional questions that can make columns visible/hidden

Question

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.

Can someone help me with this issue? Thank you.

Answer 1

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.

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.