2 formulas giving me problems great than and reciving errors, which crashes another fomula

Joey Casullo

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?

Mike Wilday

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.

Mike Wilday

=COUNTIFS([DAYS OLD]1:[DAYS OLD]11, AND(@cell >11, @cell < 20))

That should do the trick for you! Hope it helps!

Joey Casullo

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.

Mike Wilday

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.

Mike Wilday

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Joey Casullo

Thanks, Mike. I used the first option, I to new at this and do not understand the instructions. haha...

Mike Wilday

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!