#INVALID DATA TYPE

Hi


Im using the formula =IF(YEAR([Expected project completion date]@row) = 2024, WEEKNUMBER([Expected project completion date]@row), "")

If the cell "expected completion date" is blank I get #INVALID DATA TYPE. is there a way to remove this and just have the cell blank?


Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!