Year( formula issue
PeterR
✭✭✭✭
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
-
Hi,
=IF(YEAR([Project Works Commence]@row) = 2022, WEEKNUMBER([Project Works Commence]@row), " ")
Looks like a bracket in the wrong place, try that.
Tim
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!