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

Options


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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!