Formula?

Jared123456789
Jared123456789 ✭✭
in Formulas and Functions

Currently using the formula below, but the problem is Smartsheet defaults Monday through Sunday. I need it to be Sunday through Saturday =WEEKNUMBER(Date@row)

· Share on FacebookShare on Twitter

Answers

  • Jgorsich
    Jgorsich ✭✭✭✭✭

    Add 1 to date@row:

    =weeknumber(date@row+1)

    If you think you might have dates specifically on 12/31/25, you'll need to add an if() statement to prevent it from being seen as week number 1.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!