Overwrite a column formula

Marvin

Hi

Is it possible that user can modify the column formula?

Thanks.

Andrée Starå

@Marvin

Happy to help!

It's only the Owner and Admin that can set, edit or remove column formulas, and they also need a license.

Would that work?

Andrée Starå

Hi @Marvin

No, not if they don't have the correct access.

What access will they have?

Would 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!

Ellison Keller

Yes...First be sure you have Filters turned off...

Then click in first cell of column that has "fx" symbol to see options to Edit or Convert

This article might prove helpful: https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Marvin

So for example I have a column formula, people who have specific Access Role can still be able to modify the formula even if it is a "column formula"?

If yes, what access is that?

Thank you.

Andrée Starå

@Marvin

Happy to help!

It's only the Owner and Admin that can set, edit or remove column formulas, and they also need a license.

Would that work?