Using the DATEONLY function

SteveG

SteveG ✭✭

05/13/18 edited 12/09/19 in Smartsheet Basics

When I use the DATAONLY function to extract just the date from a cell in a column formatted to "Date Created" it will sometimes reflect the next day. In other words, 5/12/18 5:45 PM will come back as 5/13/18. It seems to be rounding up?

0 ·

Comments

SteveG ✭✭

05/15/18

Anyone?

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Making a new sheet after the most recent update
I used to be able to make a sheet in my own file (see img) using the Create button in the top right corner. Now I can't make a new sheet without creating a workspace around it. How do I make it not do that anymore? I just want to make a sheet for my own use and keep it in the file with all the others I'm currently using,…
Automation not Triggering on Function Checkbox
Hello, I have an automation that is setup to trigger once a particular column checkbox is checked. The column checkbox is checked by a column wide function. Prior to this I had cell level functions and the automation was working fine, not sure what the issue is now… Any help would be appreciated! Details below: when all…
Am I able to Change the Order of Items in the Legend on a Chart?
We would like to keep things consistent across the board for our PM's and business owners when it comes to the RAID Log. I have labeled them "1., 2., 3., 4." and it works in certain instances, but it's all over the place once we pull that info into charts on a dashboard. It now looks extra confusing. I am very new (3ish…

Help shape the future of Smartsheet.
Share your ideas and feature requests.