Year( formula issue

Can any one help me why this formula doesn't work. It results in #invalid operation

=IF(YEAR([Project Works Commence]@row = 2022), WEEKNUMBER([Project Works Commence]@row), " ")

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!