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

Attachments and Row Locking
I'm admin level on all of our sheets, so it's sometimes hard to test out user-level features. Can anyone let me know if users can add/delete row attachments after the row has been locked?
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "metric data" and I am trying to create conditions for the status column (Already made it a symbols column) for Gray, Yellow, and Green Green = 1 (100%) Yellow= 0.01- 0.99 (1% to 99%) Gray= 0% =IF([Metric Data]@row = 1, "Green", IF([Metric Data]@row <= "0.01- 0.99", "Yellow", IF([Metric Data]@row =…
Report Question
Bringing this to the community before I jump in to try to figure it out because you are all so helpful and smart. If I have a report "Tracker C" whos filter brings in projects which have content in a comment field called "comments". I remove comments when I want a project on Tracker C to come off of the report. I want to…

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