Subject: Issue with Dynamic Remaining Time Calculation in Reports Not Updating Automatically Body:

Bassam Khalil

Hi,

I hope this message finds you well. I am reaching out to seek assistance with a challenge I am facing in one of my Smartsheet projects, specifically within a sheet titled "Projects Info" and its connected report.

Problem Description:

In the "Projects Info" sheet, I have implemented a column formula to calculate the remaining time for project submittals. The formula used is as follows:

plaintext

Copy code
Remaining Time = NETDAYS(TODAY(), [Submittal Date]@row) 

This formula calculates the number of net working days from the current date (TODAY()) until the submittal date specified for each project row. While this formula works perfectly within the sheet itself, providing accurate daily updates, I have encountered an issue when viewing this data through a connected report.

Issue:

When I open the report linked to this sheet, the Remaining Time values do not reflect the current date calculations accurately. They seem to be outdated or not recalculated based on the current day. To get the correct, updated values in the report, I find myself needing to first open the "Projects Info" sheet to trigger a refresh of the calculations, which then allows the report to display the correct Remaining Time values upon opening it subsequently.

Attempted Solutions:

• Manually refreshing the "Projects Info" sheet before opening the report (not a viable long-term solution).
• Checking for any settings within the report or sheet that could be affecting dynamic updates (found none relevant).

Request:

Could you please provide guidance or a solution that would allow the Remaining Time calculations to automatically update within the report, without the need for manual intervention by opening the sheet first? Ideally, I am looking for a way to ensure that every time the report is opened, it reflects the most accurate and up-to-date Remaining Time values based on the current date.

Thank you for your assistance and looking forward to your valuable suggestions on resolving this issue.

Best regards,

Andrée Starå

Hi @Bassam Khalil

I hope you're well and safe!

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Hi @Andrée Starå,

Thank you so much for reaching out and for your kind wishes. I hope you're also doing well and staying safe!

I'm genuinely excited to take a look at the method you've developed for updating the sheets daily. It's always inspiring to see the innovative solutions and techniques our community comes up with. Please know that your efforts and willingness to share your knowledge are greatly appreciated.

I'll review your post shortly and share any thoughts or feedback I might have.

Best Regards