Specify conditional formula to show or hide columns doesn't work properly in a list form

Question

Hi Everyone,

I have issue with formula inside the field "Edit columns in the form". I have followed the steps from this website https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide#specify-conditional-formula-to-show-or-hide-columns and used formula, however it doesn't work. Column "Stage" is a choice list which define the stage of project. If the stage= "Data preparation" I want to show in the New item particular objects. For other stages I need to show different objects to be filled in. While using formula "IF" the object disapears, so it looks like it doesn't recognize the Stage name. (I've checked and there are no spaces/ type etc.)

Could anyone support, why this formula doesn't work as it should, please?

Answer 1

Hi @Joanna Kepa,

You should check the internal name of Stage column. The conditional formulas should be like

=IF([$Stage] == 'Data template', 'true', 'false')

---

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.

Answer 2

Hello, try it this way:

=IF([column name]="choice value", TRUE, FALSE)

Remove the "$" from your formula, so it would look like this:

=IF([Stage]="Data template", TRUE, FALSE)

If there are any misunderstandings, please let me know

Best regards，

Maycon Novaes

If the Answer is helpful, please click "Accept Answer" and upvote it.