Changing the format of a the Created (Date)
I wanted to have a date when a task was added so I am using the Create (Date) under system-generated column. "See Below" but I only want to display the date not the time. I was looking away to format the cell so it would show only the date like my other date columns and I can't find anything. Any help would be great
Best Answer
-
A few things:
- your "column27" must be a date type
- The formula is "=DATEONLY(Created@row)
- Once done, convert to a column formula and any new rows will automatically fill with formula
Answers
-
You'll have to add a so-called helper column with the DATEONLY function.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå thanks for the reply but I have two follow up questions:
First I can not get it to work please see screen shot below showing the formula I used and not sure it will work in my situation. If someone adds a new task at the bottom of the task list they would also need to add the DATEONLY function in the date field and that is a lot to ask end users to do. I hope the second part makes sense?
-
A few things:
- your "column27" must be a date type
- The formula is "=DATEONLY(Created@row)
- Once done, convert to a column formula and any new rows will automatically fill with formula
-
@Andrée Starå Great....Thanks that works
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
When using Dateonly - I am noticing that anything after 6pm is coming over as the next date in the formula.
How do I fix?
-
I am having this exact issue... Going to need some kind of workaround to resolve the next day showing up for entries after 8pm...
Help Article Resources
Categories
Check out the Formula Handbook template!