SharePoint List Entry Form Conditional Formatting Based on Yes/No response.

Question

I have a SharePoint Online list, and I'm trying to conditionally format the "new entry" form so that various questions only appear if a specific question is answered "yes".

I'm able to input and save the conditional formatting formula in the "Edit Columns in the Form" settings, but the conditionally formatted questions wont appear in the entry form no matter what is selected.

Here's the formula I'm using...

=if([$foraclient_x003f_] == true, 'true', 'false')

What I want is this - If the "For a Client?" question is marked "yes", then all the conditionally formatted questions should appear. If it's marked NO, then they don't. Right now none of them appear no matter how the "For a Client?" question is answered.

FYI the foraclient_x003f is how SharePoint views that column name, which is why it doesn't exactly match "For a Client".

Answer 1

Hi @Hoffman, Tyler ,

I created a Yes/No column with the same name as yours called "For a Client?" and its internal name is "ForaClient_x003f_".

Internal name view method:List setting->click the column name->edit column->name after "field=" in URL ( Please check your internal names, case can also affect the results).

Here's the formula I'm using:

=if([$ForaClient_x003f_] == true, 'true', 'false')

This is the result, if the "For a Client?" question is marked "Yes", then the conditionally formatted "Question" column should appear:

---

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.