Sum Network days but if field is blank results show invalid data type
Emma_w4tevr
✭✭
The subject pretty well tells it all,
I am trying to sum the network days between the request received and request sent date but if we haven't sent the request response as yet the field is empty and shows the error " Invalid data type"
Current sum is
=NETWORKDAYS([Quote Request Recieved]198, [Quote Sent Date]198)
Can someone please assist in including if the sent field isnt complete yet to show "0"? Thank you
Tags:
Comments
-
=iferror(NETWORKDAYS([Quote Request Recieved]198, [Quote Sent Date]198),0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am attempting what I thought was a simple formula to collect a value from the 'Week" column if today's date falls between a Start Date and an End Date. Here's what I have so far which returns an #IN…
- For other sheets, we use formula =IF(ISBLANK([Manually Actioned By]@row), NETWORKDAYS(Created@row, TODAY()), NETWORKDAYS(Created@row, [Manual Actioned Date]@row)) to tell us the turnaround time for th…
- I'm trying to get a running total based on if a certain drop down is used, in this case its value income total value. So if sales income is used multiple times i need the running total?