Column cannot be edited

Question

Hi,

I have 2 columns in my sharepoint list:

- Name: Intermediary type (Choice)

- Name: Remarks (Free text)

In my form, I want to condition the 2nd column to only appear if in the 1st column, 'Others' is selected.

In my conditional formula box, I put my formula in the 2nd column as:

=IF([$Intermediary type] == 'Others', 'true', 'false')

But it says "sorry we couldnt edit the column. Please try again."

Please help.

Thank you.

Answer 1

Hello FarhanahN,

Thank you for your time, we highly appreciate your cooperation.

As this behavior applied only to one column, please make sure this is a correct column type.

Currently conditional formula in not supported on the further column types:

• Calculated columns
• Person or Group with multiple selections
• Choice with multiple selections
• Time calculations in Date and Time column
• Currency columns
• Location columns
• Managed Metadata columns

You can find column types for your list on List Settings page as on screenshot below.

If Remarks column is a supported column type, may I ask you to create a new text column and check if the same issue appear on it?

Regards,

Igor

Answer 2

Hi Igor,

The answer to your question as below:

• Have any content types are applied to this list?
  • No
• Is this option is missing for all columns or only for Remarks column?
  • Only for Remarks column
• Does the similar behavior applies to other lists on SharePoint site?
  • This is my first SP list, so I havent tried in other list
• What permissions do you have for this list?
  • As a site owner, I have full control
  Thank you. Naili

Answer 3

Hello FarhanahN,

Thank you for posting back to us and sharing the updates.

Based on the screenshot and the description the option Edit conditional formula is missing.

As this is unusual behavior for SharePoint list, can you please confirm some information, so we can narrow down the source of this behavior:

• Have any content types are applied to this list?
• Is this option is missing for all columns or only for Remarks column?
• Does the similar behavior applies to other lists on SharePoint site?
• What permissions do you have for this list?

Regards,

Igor | Microsoft Community Moderator

Answer 4

Hi,

To clarify on your question, I want the 2nd column [Remarks] to appear in the 'New' form when 'Others' is selected from the 1st column [Intermediary Type]. I tried to include the formula, but there is no option to "Edit Conditional formula". I couldnt click the option for the "Remarks" column to either show/hide either.

Answer 5

Dear FarhanahN,

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

May I know if you want the box to insert remarks appear only when in Intermediary type column Other choice is selected when create a new item in list?

Screenshot for reference:

In this case you need to insert formula to a list form

Go to your SharePoint Online list > Open the New Item form by clicking on the New button in your list.

On the New item page, click on Edit Form button and then Edit Columns as in the below screen.

Now, on the Edit Columns form, click on the three dots and choose Edit Conditional formula from the menu next to Remarks column.

In the conditional formula, Enter the formula to show and hide the field. I have entered =if([$Intermediarytype] == 'Others', 'true', 'false') and hit save to commit your changes. Be sure you are using Internal Names of the columns, instead of display name.

If my understanding doesn’t match your situation, feel free to post back to us and point that.

Sincerely,

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