Adding isblank into my formula

Options

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)

Answers

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Options

    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.



    👨🏼💻Dan Palenchar |School of Sheets Solutions Consulting| Smartsheet Aligned Gold Partner

    If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

    PS - If you have a follow up response attention use@Dan Palencharso I get notified of your reply!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!