Date format with Time
Dear Sir,
We are unable to keep the date format along with the Time.
Example: 12-Oct-2020 12:13 PM
Need your advise.
Thanks and best regards.
Best Answer
-
Dear Thinh,
I did some workaround to get the approval date and time. At time of each approval level copying the same record to another sheet (As a history table) and take record creation date from history table using Vlookup function.
Refer below screen shot.
Formula :
=IFERROR(LEFT(VLOOKUP([Srl #]@row + 1, {HR Workflow History Range 3}, 2, false), 8) + " " + RIGHT(VLOOKUP([Srl #]@row + 1, {HR Workflow History Range 3}, 2, false), 5), "")
First Section: Date & Second Section: Time
I am using above functionality to get Approval date and time.
Thanks.
Answers
-
Hi @Syed Abdul Majid,
As i know, Smartsheet does not yet support date format along with the time for user-generated date collumn (except for system-generated collumn)
Hope they will consider this issue!
-
Dear Thinh,
I did some workaround to get the approval date and time. At time of each approval level copying the same record to another sheet (As a history table) and take record creation date from history table using Vlookup function.
Refer below screen shot.
Formula :
=IFERROR(LEFT(VLOOKUP([Srl #]@row + 1, {HR Workflow History Range 3}, 2, false), 8) + " " + RIGHT(VLOOKUP([Srl #]@row + 1, {HR Workflow History Range 3}, 2, false), 5), "")
First Section: Date & Second Section: Time
I am using above functionality to get Approval date and time.
Thanks.
Help Article Resources
Categories
Check out the Formula Handbook template!