I need it to return blank

Diego Casillas Zaragoza

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?

Mike matthys

=IF([Shipped date]@row = ""; ""; ROUND((([Shipped date]@row - DATE(2021; 10; 31)) / 7) + 0,49; 0))

Diego Casillas Zaragoza

DId not work.