Time Indication and DATEONLY function



I have a few questions below regarding Smartsheet:

  1. We're utilizing Smartsheet to track start time and end time in a 24-hour clock to count the duration of some of the tasks we complete.
  2. How can I remove the time in "Created", I would only like to have the date. (photo 2)

Question 1 Explanation below:

I've noticed some of our front line staff will input times like "0412 or 0420" indicating 4:20 am. However, the Smartsheet won't register this number as 0412 or 0420 but as 412 or 420. Is there a way to make sure the time shows 0412 or 0420 and not 412 or 420?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!