Hyperlink reports

Samuel Dowdy Jr.

Is there a better way to quickly create reports to correlate with the week?

Brett Wyrick

First off, are you referring specifically to Smartsheet Reports?

And if so, do you mean rather than simply displaying results to a generic "Weekly Report", in your solution here you'd want auto-created reports named something like "week of 06/05/21" per week?

Samuel Dowdy Jr.

Yes, I want to auto generate reports for the week.

like "Estimate Report Week 49_2021" I would one for every week of the year.

Andrée Starå

Hi @Samuel Dowdy Jr.

I hope you're well and safe!

Here's a possible workaround or workarounds

• Create a report for each week that checks for the WEEKNUMBER.
• Structure a solution with a so-called helper sheet (Master Metric Sheet) with an easy way to select the week you'd like to show the data for and add a report referencing that sheet. Add the helper sheet and the report to a folder and make a copy for each week and then update the week number in each helper sheet.

Make sense?

Would any of those options 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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!