2 formulas giving me problems great than and reciving errors, which crashes another fomula
My formula is =COUNTIFS([DAYS OLD]1:[DAYS OLD]11, >11) I need great than 11 but not to exceed 20. How would I do that?
Also, I am getting an error when I do have a date in this formula, =NETWORKDAYS(Delivered11, d11) how do I get the error to report a 0 when a delivered date is blank?
Best Answer
-
Sorry! Try wrapping it in an IFERROR formula. =IFERROR(NETWORKDAYS(Delivered11, d11),"") This will leave the cell blank if an error appears. You could also probably convert that into a column formula too so you don't have to update it on each line.
Answers
-
=COUNTIFS([DAYS OLD]1:[DAYS OLD]11, AND(@cell >11, @cell < 20))
That should do the trick for you! Hope it helps!
-
It fixed the first problem, thanks so much I tried for over an hour.
But what about the other question of =NETWORKDAYS(Delivered11, d11) this formula gives me "#invaidid data when I and trying to count days from a "Delivered" date from "d" date, Some of my fields in delivered are blank since they have not delivered yet. My problem is it crashes an other formula pulling from the count cell.
-
Sorry! Try wrapping it in an IFERROR formula. =IFERROR(NETWORKDAYS(Delivered11, d11),"") This will leave the cell blank if an error appears. You could also probably convert that into a column formula too so you don't have to update it on each line.
-
-
Thanks, Mike. I used the first option, I to new at this and do not understand the instructions. haha...
-
If you add that formula for calculating your Days old... you can right click it on it and make it a column formula which will automatically apply to the entire column!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!