Week number formula



I want to search the week but also only 2022 weeks as my sheet also has 2021 and i don't wish to display those.

This is what i have today

=WEEKNUMBER([Project Actual Completion Date]@row)

Thanks for your help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!