I need it to return blank

Hello,


I am currently using this formula, which works fantastic, =ROUND((([Shipped Date]@row - DATE(2021, 10, 31)) / 7) + 0.49, 0) but if there is no date entered on the shipped date column, it returns a 0. how can I make it be blank instead of 0?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!