Error in Sharepoint Lists conditional column formatting in List Form

Question

Hi there,

I have a list which includes a Choice column, called 'Description' and a DateTime Colum : 'Date de reprise'

The 2 options in 'Description' are: Reprise and Creation

I want the DateTime column field to only appear in the form when the Description is 'Reprise'. Otherwise, I want to hide it.

I have added this formula in the conditional format field of the Date column :

=if([$Description]=='Reprise','true','false')

I don't see error in the formula, but I have the following error message :

"Désolé... Nous avons rencontré un problème

La formule contient une erreur de syntaxe ou n'est pas prise en charge." Can you help me ?

thanks !

Answer 1

Dear Franck,

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

According to your description, I have tested on my side. It works well and won’t pop on the error message. Based on the situation, I would like to confirm if your steps are the same as mine. Here are my steps:

 

If the situation still happens, please change to another browser and open the private window of the browser to access the SharePoint list, then test again.

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | 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".***

Answer 2

Hi Franck,

I'm writing this reply to follow up on this thread, may I know if you have checked my replies? When you have time, you are welcome to come back and share any updates with us.

Sincerely,

George | 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".***

Answer 3

Dear Franck,

Also, since you mentioned you want the DateTime column field to only appear in the form when the Description is 'Reprise', the original formula won’t hide the DateTime column when the Description column is empty. You can use the following formula to hide the DateTime column when the value in the Description column is Creation or Empty. Check if it helps.

=if([$Description] == '' || [$Description] == 'Creation', 'false', 'true')

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | 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".***