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

Question

I have a list which includes:

• Choice column: Review Status
• DateTime Colum: Review Date.

The 6 options in Status are: New, Submitted, Ready for Review, Review Scheduled, Review Complete- Approved, Review Complete- Denied

I want the Review Date field not to appear in the form when the Status is New and to appear when the Review Status shows any other selection (Submitted, Ready for Review, Review Scheduled, Review Complete- Approved, Review Complete- Denied). Basically, I want it hidden on an initial submission.

I have added this formula in the conditional format field of the Review Date column which I have taken directly from MS's website regarding showing/hiding columns in a list form, I switched the true and false to meet the requirement. (this formula has worked in other SharePoint Lists I have created):

=if([$ReviewStatus]=='New','false','true')

The field does not appear with the formula when the Review Status is New, the problem is that the field does not appear for any Review Status. the Review Date column does not respond to a value change in Status. I have tried refreshing the form, changing the column names, deleting and recreating the column and nothing seems to work.

Quick Note: I have 5 other fields I am attempting to perform the same action.

Answer 1

Hi- I have followed your instructions (screen prints attached), unfortunately the field is still visible in the form.

Answer 2

Dear jrvr_36

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

Based on your description, it seems that you want to use the formula in the conditional format field to achieve the requirement: when the Status is New, the Review Date field not to appear in the form, and if the status is other 5 options, the Review Date field appear in the form.

We did a test in our end by the formula you provided by click the item in the list>Edit columns>click Edit conditional formula>then input the formula in the box, and in the first several tests, the formula can't work well in our end. We suspect maybe there are some problems with the formula, so we add the space in the formula, and then the formula can work well in our end as the screenshot below:

So please open an InPrivate window or change to a different browser then type the formula with space by following the steps in above steps to check if the formula can work well.

Besides, by our many time tests, we found there are some weird behaviors with the original formula you provided, in the first several tests, the formula didn't work, and we even can't click the save button to save the formula, but in later test, the formula seems can work well.

If the formula still can't work in your end, please provide a screenshot of the List Form as the screenshot below to us so that we can have a better understanding.

We’re looking forward to your reply and will continue to help you all the time!  If there are any misunderstanding or unclear, You can post back in your free time.

Sincerely,

Stacey | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save". ***