If Year is 2024, give week of year
Looking for help to create a formula that looks at a column and if the year is 2024, give the week of the year.
Best Answer
-
Hello @Breelyn Brown
There are 52 weeks in a year. This formula will return which number of the week:
=WEEKNUMBER([Date Column]@row)
This will check IF the year is 2024 then provide the WEEKNUMBER
=IF(YEAR([Date Column]@row) = 2024, WEEKNUMBER([Date Column]@row), 0)
You can replace the 0 with whatever you want to say in quotes like "Not 2024" for when 2024 is not found.
For this to work make sure the properties of your date column in Smartsheet are a "DATE".
Answers
-
@Breelyn Brown Hi, assuming your date column is named "date", use this formula. It should give you the week of the year for that specific cell. =IF(YEAR(date@row) = "2024", WEEKNUMBER(date@row))
If my response answers your question, please mark it as accepted.
-
Hello @Breelyn Brown
There are 52 weeks in a year. This formula will return which number of the week:
=WEEKNUMBER([Date Column]@row)
This will check IF the year is 2024 then provide the WEEKNUMBER
=IF(YEAR([Date Column]@row) = 2024, WEEKNUMBER([Date Column]@row), 0)
You can replace the 0 with whatever you want to say in quotes like "Not 2024" for when 2024 is not found.
For this to work make sure the properties of your date column in Smartsheet are a "DATE".
-
Thank you so much! The formula worked :)
-
Happy to hear this formula worked for you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!