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.
#UNPARSEABLE
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!
Comments
-
The formula looks OK.
Do you have 3085 rows? If you don't, that is that error. The 3085 is the row reference.
Craig
-
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))
