Index Match (No Match)

Im pulling in information from another sheet to the sheet in the image below and I cannot figure out how to only make the date show up when there is a match. I do not want "No Match" to appear.

=INDEX({picked up}, MATCH([Ticket #]@row, {ticket number}, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!