Control Center Error message

Carol-Anne Cerbone

I am new to Control Center and I'm trying to do a global update to a formula. Here is the formula I want to change

Current Formula:

=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = MONTH(TODAY())), 1)

New Formula:

=IF(AND(YEAR(Date@row) = YEAR(TODAY()), MONTH(Date@row) = MONTH(TODAY())), 1)

Changing Created@row to Date@row. When I test my update I am receiving the following error message:

I'm not sure what I am doing wrong. The Date column is checked as 'Restrict to Date Only'.

Thank you in advance for any assistance

Carol-Anne

Find more posts tagged with

Control Center

Accepted answers

All comments

AravindGP

Hi @Carol-Anne Cerbone

The error is due to the column where you're trying to update the formula. Currently, Global Updates doesn't allow for a column formula to be updated. It has to be done in each sheet manually. Alternatively, you can create a new column through Global Updates with the new formula to roll it out to all sheets.

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.