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))
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives