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?

Tags:

Best Answer

Answers

  • AndrΓ©e StarΓ₯
    AndrΓ©e StarΓ₯ Community Champion
    Answer βœ“

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Jon Tandy
    Jon Tandy ✭✭
    edited 02/24/21

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!