Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.


Angie Hatfield
Angie Hatfield ✭✭✭✭
edited 10/03/17 in Archived 2017 Posts

I am using the following formula to calculate the net days but only if the dates are listed. What am I doing wrong?

=IF(AND(ISDATE([Date Received]3085), ISDATE([Processing End Date]3085)), NETDAYS([Date Received]3085, [Processing End Date]3085), "")



Thank you much!





SS Screenshot.jpg

SS Screenshot.jpg


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    The formula looks OK.

    Do you have 3085 rows? If you don't, that is that error. The 3085 is the row reference.


  • Angie Hatfield
    Angie Hatfield ✭✭✭✭

    I figured it out. I just kept playing with it until it worked. Yes, this particular sheet has over 3085 rows, that's just the one I was working with. I also changed it to NETWORKDAYS.

    I saved this to my frequently used SS. I imagine I will be using it a lot now.

    Thanks for your help!


    =IF(AND(ISDATE([Date Recieved]3085), ISDATE([Processing End Date]3085)), NETWORKDAYS([Date Recieved]3085, [Processing End Date]3085))

This discussion has been closed.