Avoid no match until data is populated


I am pulling information i.e. a date, from one spreadsheet over to another spreadsheet. Since the date field may still be empty on the source sheet, the formula displays "no match" on the spreadsheet. Once a date is being added to the source sheet, then the formula displays the date on the other spreadsheet. How can I suppress seeing "no match" until a date is being entered? I tried to use conditional formatting, but that does not work i.e. if date - use black font, if no match - use white font. That does not work. Any other suggestions?

Thanks for your assistance.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!