hide formula errors

Ian Staley

Hello,

 

I have WORKDAY formulas that are correct, but there is insufficient data to return a value in the formula cell so I'm getting an error. (There's no due date yet) What I would like is a way to simply hide those errors, but still have values appear when due dates are entered entered into the cells they reference to return a proper value.

 

Is that possible?

 

 

Brett Evans

=IF(IsBlank([DueDate]1), "Bad User, no due date!", OriginalWorkDayFormula)

Ian Staley

That's absolutely amazing. Exactly what I needed. Thank you!

J. Craig Williams

Just released ISERROR() and IFERROR() functions (2016-08-06)

Check 'em out:

 

https://www.smartsheet.com/release-notes

 

Craig