Converted from Column Formula to Cell Formula, but cant edit in Dynamic View
I have a few fields which are in a dynamic view and are not editable.
These fields are NOT set to read-only in the dynamic view.
In the Source Sheet, they are editable, just not the dynamic view. These fields are not currently a formula field. They previously were a column formula and I converted them to Cell Formula so that they could be edited in the source sheet (which works perfectly fine). We just can't edit them in the dynamic view. When I hover over the fields in the source sheet, it shows me the original formula that the field was created with.
How do I ensure that this field is just a text field and not a formula so that it can be edited in the dynamic view
Answers
-
You would have to remove the formula completely.
-
I figured it out about 15 minutes after I posted this. When I converted it back to cell formula, I still had to copy and paste values for the columns. Once I did that, it fixed the problem.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!