Can't edit/delete calculated column from sharepoint list

Anonymous
2020-06-20T22:59:12+00:00

I created a new list on my sharepoint site.  I created two date columns and a third calculated column to calculate the difference.  I can create the column and formula just fine but I have no option to edit the calculated column once created or delete it.  I must be missing something.  Any ideas?

There is no "edit" option for the calculated column.  I have tried on multiple lists and get the same behavior.  On other columns I get the "edit" option

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2020-06-21T02:24:15+00:00

    Hi Tamir,

    Thanks for your feedback in this community.

    I can confirm that I have the same behavior as you described in my test tenant. Not only the Calculated column, but also the managed metadata column. Actually, per my test, if you add the column via the following method, the columns will have that Edit button.

    However, that doesn't mean you won't be able to edit your calculated/metadata column, please go to the List Settings > Columns > Find your calculated column and click on its name, it will redirect you to the column edit page and you can edit the calculated column there.

    Regards,

    Alex Chen

    66 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2020-06-21T05:24:10+00:00

    Thanks Alex - that works.  I knew there had to be a way.

    1 person found this answer helpful.
    0 comments No comments