Microsoft List Drop and down

Question

In Microsoft List I created a dropdown with choices ok and not ok. If user select not ok then he should get a column with single line text to mention comments and if he select ok the column should be in hide mode.

Is it possible in microsoft list.

If not what are the alternatives.

Answer 1

Hi @Vamsi Chavali,

Thank you for posting in this community.

Unfortunately, we don't have a way to hide the column.

However, we can create a column of type Calculated to determine whether to populate the calculated column with the comments based on the value of the selected column.

Here are steps:

1. See all column types.

2.Select the column type is Calculated.

3.Fill this formula in Formula.

=IF([IsOk]="not ok","Your  mention comments","")

I will explain this formula to you briefly.

The first part of the IF function is the judgment condition, where we use [column name] to get the value of the dropdown column, so remember to replace the middle bracket with the name of your column.

The second part of the IF function is the operation in which the judgment condition is valid, where we fill in the comment you mentioned.

The third part of the IF function is the operation in which the judgment condition is not valid.

Click the OK button at the bottom of the page when you are done.

Here is result of my test:

---

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.