Date Formatting from a Formula


I'm importing dates from an excel sheet that have a time stamp, and I have a formula that removes the time stamp in Smartsheet. This is fine except the date won't convert to 00/00/00 for that column. Does anyone know if there's a way to covert the format?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!