Sharepoint Lists conditional column formatting in List Form not working despite correct formula.

Question

I have a list which includes a Choice column: Status and a DateTime Colum: Award Date.

The three options in Status are: Awarded, In Progress, Not Started.

I want the Award Date field to only appear in the form when the Status is Awarded. Otherwise, I want it hidden at all times.

I have added this formula in the conditional format field of the Award Date column which I have taken directly from MS's website regarding showing/hiding columns in a list form:

=if([$Status]=='Awarded','true','false')

Despite the above formula being in the correct place, the Award Date column does not respond to a value change in Status, regardless of the value selected. I have tried refreshing the form and changing the column names and nothing seems to work despite following the syntax perfectly.

Answer 1

Hi rKelsey,

Thank you for posting your query in our community.

Based on your description, you want to Show / Hide fields based on choice field selection on SharePoint Online using formula. I tested your formula on my side, there was no problem. From below pictures you can see that once the formula for the field has been set, you will notice that it becomes grayed out. May I confirm that whether you have set the formula successfully?

If not, please try to manually enter the formula to see the result.

Best regards,

Jazlyn

Answer 2

The formula I've used is exactly what you have used. The column is being greyed which indicates the formula is in the correct syntax.

For more clarification, I created the Sharepoint List from an Excel file, it was not something that I generated manually. I am having the same issue when updating an existing row and when I'm adding a new one. Does the list creation method have an impact on Column show/hide?

Answer 3

Hi rKelsey,

If we enter the custom formula in the Edit columns pane like above, the formula only affect the Details pane on the right.

Given this situation, we suggest that you could create a new Calculated type column, and enter below formula. Then you can hide the Award Date column in the list. Then once you change the status for the existing items, the data will show based on the choice.

Best regards,

Jazlyn

Answer 4

Hi rKelsey,

Did you try the method in my last reply?

Best regards,

Jazlyn