Unable to edit column formulas

I'm the owner of numerous sheets and have been excited playing around with the recent addition of column formulas. However it seems like once I have created one I am unable to edit it, even as the owner of the sheet. It just gives me a little grey message saying "I have to be owner or admin of the sheet to edit".

As a work around I've been deleting the column with it in and recreating it but this does get a bit time consuming. Am I the only one having this issue as I've not found any other posts about this?

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

Hi @Ricky Woodage

You’ll need to right-click on any cell in the column and select Edit Column Formula.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Ricky Woodage

You’ll need to right-click on any cell in the column and select Edit Column Formula.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Jon Tandy

I have the same question. I am the owner of a sheet and have created several column formulas. I am logged in under my e-mail address. In the sheet properties, my e-mail is listed as the creator and the owner. But it still won't allow me to edit a column formula.

Edit Column Formula isn't even an option when I right-click. Also, this problem just started this afternoon. I was editing column formulas this morning.

Jon Tandy

https://community.smartsheet.com/discussion/comment/280831#Comment_280831

Follow up to my question - problem seems to be solved. I can edit the column formula after all, if I have not selected the entire column; but there are two cases where the option to edit the column formula is unavailable:

1) right-click on the column header or the "fx" at the top of the column (where the warning message appears about not being able to edit the formula) doesn't allow column formula to be edited.

2) select the entire column, then right-click on any cell, also doesn't show the option to edit column formula.

But if the entire column ISN'T selected, then right-click on any cell, it DOES allow the menu to Edit Column Formula.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.