How to get the current week Dates Dynamically
Shaik. Baru
✭✭✭
Hi there,
I've created a user level Timesheet, where users have access to update their Timesheets on weekly basis. User wants to see the current week Dates.(Eg; Wk 50 "Mon 11Dec - Fri 15Dec")
Please find the below screenshot for reference. I've tried using today's date formula, somehow it shows the next week dates. Is there any way to show the current week dates dynamically?
Answers
-
Are you trying to base the dates of the days of the week off of the current week number ?
What "starts" the value in {Current Week}1 ?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!