Importing Dates

Mitch Cohen

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 ??

Paul Newcome

You could try setting up a Clear Cell automation set to trigger when that field changes to that string.

Mitch Cohen

Thanks Paul, I have never used "clear cell automation", I need to research that.

Andrée Starå

Hi @Mitch Cohen

I hope you're well and safe!

More info.

https://help.smartsheet.com/articles/2482382-clear-cell-value-action

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!