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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!