Hi Community, report not update

I got the formula below, but not updating and keep going back 0

=COUNTIFS({Operations Report Range 1}, AND(IFERROR(MID(@cell, (FIND(":", @cell) - 2), 2), "") >= 13, IFERROR(MID(@cell, (FIND(":", @cell) - 2), 2), "") <= 16), {Operations Report Range 3}, AND(WEEKNUMBER(@cell) = WEEKNUMBER(Date@row), WEEKDAY(@cell) = 2))

I opened the sheet and saved, my report showed 1 or more, but the report showed 0 again after about 20 mins later.

Find more posts tagged with

Accepted answers

All comments

Julio S.

Hi @Kin,

The Activity Log and Cell History in the sheet might be able to give you more context about the specific changes within the sheet that led to the values returned by the formula being updated.

If you find that the changes made in the sheet when the values last changed to 0 don't make sense or look unexpected, I would recommend opening a ticket with our Support team via this form. Please make sure to include captures of the Activity Log and Cell History that can provide more context to the reported behavior.

I hope that this can be of help!

Cheers!

Julio

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