Sign in to submit new ideas and vote
Get Started

Formula that Calculates Week Range and Labels Week Number Accordingly

When integrating our billing week system that alternates between billing weeks 1 and 2. Smartsheet should have a formula that allows for the duration to have a range based on weekdays that triggers to automatically label every other week with either week 1 or 2 accordingly.


Week Start Date End Date Name Total Hours

1 Jan 9 Jan 14 Charlotte 48

2 Jan 16 Jan 20 Charlotte 30

2 votes

Idea Submitted · Last Updated