Has the ability to state a type (start day) in WEEKNUMBER been removed
I had this formula which generated a week number with the start date being Friday due to the type being '15'
=IF(Date@row <> "", WEEKNUMBER(Date@row, 15), "")
which used to work.
Now the type within the function seems to be ignored.
Has the ability to specify a week start date within the WEEKNUMBER function been removed
Thanks
Best Answer
-
Hey @RichardJ
It sounds like you may be referring to an Excel function. Smartsheet's WEEKNUMBER Function does not have the ability to add in a "type" to adjust when the week starts. Smartsheet calculates week numbers based on Mondays.
Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!
In the meantime, how I personally adjust this is by using the WEEKDAY function as well. I my sheets, my work week starts on a Sunday, so I've adjusted the formula like so:
=IF(WEEKDAY(Date@row) = 1, WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))
If your week starts on a Friday, you could do something similar:
=IF(OR(WEEKDAY(Date@row) = 1, WEEKDAY(Date@row) >= 6), WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hey @RichardJ
It sounds like you may be referring to an Excel function. Smartsheet's WEEKNUMBER Function does not have the ability to add in a "type" to adjust when the week starts. Smartsheet calculates week numbers based on Mondays.
Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!
In the meantime, how I personally adjust this is by using the WEEKDAY function as well. I my sheets, my work week starts on a Sunday, so I've adjusted the formula like so:
=IF(WEEKDAY(Date@row) = 1, WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))
If your week starts on a Friday, you could do something similar:
=IF(OR(WEEKDAY(Date@row) = 1, WEEKDAY(Date@row) >= 6), WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives