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)), "")
Answers
-
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.
Gia Thinh Technology - Smartsheet Solution Partner.
-
Hi,
You want me to open 100+ sheets everyday? Is there any other way to make this work?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!