How do I replace the error Message "#NO MATCH" with other Text?

m.gipson@pqegroup.com
โญโญ
I have a formula that looks for "0" in a row then puts the Date above that 0 in a cell.
But of there are no 0,s in a Row it returns an Error Message of" #NO MATCH" I want to replace this error with Not Available. Does anyone know how to do this?
Answers
-
=iferror(your equation goes here,"Not Available")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!