If Year is 2024, give week of year

Looking for help to create a formula that looks at a column and if the year is 2024, give the week of the year.

Best Answer

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    Answer ✓

    Hello @Breelyn Brown

    There are 52 weeks in a year. This formula will return which number of the week:

    =WEEKNUMBER([Date Column]@row)

    This will check IF the year is 2024 then provide the WEEKNUMBER

    =IF(YEAR([Date Column]@row) = 2024, WEEKNUMBER([Date Column]@row), 0)

    You can replace the 0 with whatever you want to say in quotes like "Not 2024" for when 2024 is not found.

    For this to work make sure the properties of your date column in Smartsheet are a "DATE".

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!