Weeknumber or other loop option

Options
✭✭✭✭

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!

• ✭✭✭✭✭✭
Options

Try this...

=IF([Calendar Week (1-52)]52 + 1 <= 52, [Calendar Week (1-52)]52 + 1, 1)

• ✭✭✭✭✭✭
Options

Try this...

=IF([Calendar Week (1-52)]52 + 1 <= 52, [Calendar Week (1-52)]52 + 1, 1)

• ✭✭✭✭
Options

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)

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!