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

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would have to remove the formula completely.

NickO

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.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.