Discrepancy with results in sheet vs report

Hi,

I am using a formula in 100+sheets and it works well. But, when I pull the sheets in a report, the results are changing yet in the sheet the results are correct. For. ex: The formula is to calculate the due date count, for the same date the results are showing differently in the report like below.

Formula I am using-

=IFERROR(IF(Done@row = 1, "Complete", IF(TODAY() <= [Due Date]@row, NETWORKDAYS(TODAY(), [Due Date]@row, {Pivot Sheet Range 1}) - 1, NETWORKDAYS(TODAY(), [Due Date]@row, {Pivot Sheet Range 1}) + 1)), "")

Find more posts tagged with

Accepted answers

All comments

Gia Thinh

Hi Joyjenz,

Each row in the report belongs to different sheets.

Your formula contains the TODAY function that need you open the sheets and save them everyday to update the result. This may lead to different results of sheets, then show different results on your report.

Open all the sheets and save them then check the report again.

Joyjenz

Hi,

You want me to open 100+ sheets everyday? Is there any other way to make this work?

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.