Same Formula (=WEEKNUMBER(Date@row)) Different Result

Christen

Hello, Smartsheet Gurus!

I am stumped. I am using the same =WEEKNUMBER(Date@row) formula in two different sheets. One sheet is pulling information from the other using the project number, employee name, and week number.

I could not figure out why the data is wasn't pulling over because I used the same setup over and over again. Then I realized the formula =WEEKNUMBER(Date@row) result in each sheet was different; off by 1 week.

Thoughts on why this happens and how to correct it?

Thank you in advance 😁

LeelaLodhi03

Hi @Christen,

This can happen due to timezone differences or variations in the underlying date values across sheets.

Verify both sheets are aligned in terms of timezone (sheet owner can impact this).
If the discrepancy occurs around Sundays, adjusting the formula to =WEEKNUMBER(Date@row + 1) can help align results.