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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 142 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives