FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SET

DianeKayle

Hello,

I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formula on blank cells. Can someone help me please?

Column names:

Original End Date, New End Date and

Screenshot_1.png

Planned Task Hours

Devin Lee

Hey @DianeKayle,

I generally put in an IF statement to see if a cell is blank. The formula below checks to see if Original End Date is blank and if it is returns blank but if it's not blank it will preform the calculation.

=IF([Original End Date]@row = "", "", NETDAYS([Original End Date]@row, [New End Date]@row))

Devin Lee

Hey @DianeKayle,

I generally put in an IF statement to see if a cell is blank. The formula below checks to see if Original End Date is blank and if it is returns blank but if it's not blank it will preform the calculation.

=IF([Original End Date]@row = "", "", NETDAYS([Original End Date]@row, [New End Date]@row))

DianeKayle

Hi Devin, that helped however, I also need a formula if one of the 2 cells involved is blank. Can you help?

Paul H

Try wrapping you formula with an IFERROR

IFERROR(your formula here, " ")

https://help.smartsheet.com/function/iferror