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
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 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!