Weeknumber or other loop option

Hello Smartsheet community!
I have a column where I insert a week number as a start week for a project and then I use it to map activities by week. Currently, I start the column with the first week of the project and then fill/drag it down to fill the column in order to feed into dashboards. My problem is that I have projects that start mid-year/month, e.g. Week 20. I have to fill 20, 21, 22 - 52 then restart my sequence 1, 2, 3...-19. Is there a way to create a +1 or another loop so I can insert a single starting week and then have it fill to 52 and then start back at 1?
Easy +1 option that works but doesn't reset at 52. =[Calendar Week (1-52)]52 + 1
Does anyone have any good tips or ideas for a weeknumber +1 that will loop back to 1 after 52?
Thanks in advance for any ideas!
Best Answer
-
Try this...
=IF([Calendar Week (1-52)]52 + 1 <= 52, [Calendar Week (1-52)]52 + 1, 1)
Answers
-
Try this...
=IF([Calendar Week (1-52)]52 + 1 <= 52, [Calendar Week (1-52)]52 + 1, 1)
-
Brilliant!! Thank you, Paul!
Note for any future users searching the forum. [Calendar Week (1-52)] is my column name and the 52 after the ] was the row I pasted in my original post. I want to insert a singular starting week in row 1 and then have the formula populate so I started in row 2 with the proper row in the formula provided by Paul and it worked perfectly.
=IF([Calendar Week (1-52)]1 + 1 <= 52, [Calendar Week (1-52)]1 + 1, 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!