Current Week Formula

Options
Megan Harry
Megan Harry ✭✭
edited 06/17/22 in Formulas and Functions

I use the formula listed below quite often but sometimes different variations. I am having trouble with this specific one because it is pulling the previous year's entries as well when I only want the current year. I have tried a couple of things but can't seem to get the syntax right. I think I need to use something like YEAR(Date@row) = YEAR(TODAY() but can't seem to get it. Any suggestions? @Paul Newcome I think you were the one to help me with learning this formula a while back! Do you mind assisting? Thank you!

=IF(WEEKNUMBER(Date@row) = WEEKNUMBER(TODAY()), 1)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!