Column formula from a template not allowing me to edit
I downloaded a Smartsheet template and am now listed as the owner, however it is not allowing me to edit a column formula. The column isn't locked, but the formula is somehow.
Answers
-
I was able to find my answer. Thank you.
-
Hi @Shannon23
I'm glad you were able to find an answer!
For anyone else having the same problem, to edit a Column Formula, you will need to right-click on a cell in that column for the option to appear in the drop-down menu. More information can be found in our Help Center, here: Set Formulas for All Rows with Column Formulas
Cheers,
Genevieve
-
Frustrating when someone asks what seems to be the exact question I have and then says nevermind. I have a template that I downloaded and there is a column formula calculating a percentage. When I right click on any cell in the column, I get a dropdown menu, but no option to edit the formula. "Convert to Column Formula" is greyed out.
-
Hi @JWMorgan77
Can you post what formula is in that column?
It sounds like that specific formula may have a row reference in it (e.g. [Column Name]1 instead of [Column Name]@row)
Here's more information on what makes a formula eligible for a column formula.
Cheers,
Genevieve
-
Thank you for your response. I am new at Smartsheets and found that the columns were controlled by Project Settings where start date, end date and Duration are setup.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!