# Adding isblank into my formula

Hi All,

I am hitting a wall with adding isblank into my formula. I currently am tracking total number of days from project requested to completed. If the value is 0 I want the field to be blank. How do I combine the two?

=SUM([Project Complete Date]@row - [Project Requested]@row)

• ✭✭✭✭✭✭

I would suggest using

=IFERROR(IF(NETDAYS([Project Requested Date]@row, [Project Complete Date]@row) - 1 = 0, "", NETDAYS([Project Requested Date]@row, [Project Complete Date]@row) - 1), "N/A")

The NETDAYS function calculates the number days between two dates, it returns 1 if the dates are the same so this formula is adjusted to subtract one day. If both date fields are not added with actual dates, an #INVALID DATE TYPE error would show, so the IFERROR portion causes this situation to return "N/A" which just looks a little nicer.

School of Sheets (Smartsheet Partner)

If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!