Importing Dates

Mitch Cohen
Mitch Cohen ✭✭✭✭
edited 02/27/23 in Formulas and Functions

I am importing a manufacturer's shipping report into Smartsheet with Data Shuttle. If the product has not shipped, the manufacture has a date of 00/00/0000. When I import the data, I want the date to be blank, if the date equals 00/00/0000. How can I make the cell blank if it the date imported is 00/00/0000 ??


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!