Returning a BLANK cell with IFERROR
Good Morning.
I am trying to make this formula return a blank cell instead of #INVALIDDATATYPE if not using the IFERROR syntex or #UNPARESABLE how I currently have it built. What am I missing?
=NETDAYS([Projected Delivery]@row, [Cleared RCI]@row)  1, IFERROR(@cell), 0)
Thank you!
Best Answer

Hi @kblood ,
Try nesting the formula within the IFERROR:
=IFERROR(NETDAYS([Projected Delivery]@row, [Cleared RCI]@row)1,"")
This basically tells Smartsheet to run the NETDAYS1 formula, but if there's an error, display a blank cell.
Hope this helps. Let me know if it works!
Best,
Heather
Answers

Hi @kblood ,
Try nesting the formula within the IFERROR:
=IFERROR(NETDAYS([Projected Delivery]@row, [Cleared RCI]@row)1,"")
This basically tells Smartsheet to run the NETDAYS1 formula, but if there's an error, display a blank cell.
Hope this helps. Let me know if it works!
Best,
Heather

That did exactly it!! I have such a hard time knowing the proper order to build a formula. Thank you so much!!!

@kblood Happy to help! The order of formulas definitely makes a huge impact and can be tricky to set up.
With IFERROR, I always have to think of it as the following:
=IFERROR(Formula, What to do if the formula fails)
Generally speaking, my IFERRORS are almost always the furthestexterior (if that makes sense) function in the formula; however, there are some more complex scenarios in which the IFERROR(formula, what to do if the formula fails) is nested within another formula.

Hello, Where would I add the IFERROR, so I can have it show a blank when there isn't a date, instead of #INVALIDDATATYPE ?
=IF(MONTH([Due date]@row) < 4, "Q1", IF(MONTH([Due date]@row) < 7, "Q2", IF(MONTH([Due date]@row) < 10, "Q3", "Q4")))

I would actually use ISDATE in this scenario, so you could add an IF statement at the front of your formula like so:
=IF(ISDATE([Due Date]@row), the rest of your formula, otherwise "")
or:
=IF(ISDATE([Due Date]@row), IF(MONTH([Due Date]@row) < 4, "Q1", IF(MONTH([Due Date]@row) < 7, "Q2", IF(MONTH([Due Date]@row) < 10, "Q3", "Q4"))), "")
Cheers,
Genevieve

Thank you so much, Genevieve! This worked beautifully!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!