We have a timecard system that generates a report for us, however it lists "Time in" and "Time out" in the format: mm/dd/yy HH:MM (military time).
I need to separate these into their own columns, Date and Time. Any idea how I can do that?
I would use FIND to determine the position of the second slash, and use that position with LEFT to get the date portion.
=LEFT(DateTimeColumnname@row, (FIND("/", DateTimeColumnname@row, 4) + 4))
This says to find the position of the slash starting with the 4th position from the left and going right, add 4 to that, and give me everything to the LEFT of that position.
Then if you use =RIGHT(DateTimeColumnname@row, 5) you should get the time portion.
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi, I am wanting to display multiple vlookup results from a separate sheet into 1 cell. Example: Cabling Allocation Sheet, where we input an allocation to a text name "ECC" which can be multiple cables in the same run. Requirements Sheet - Need the output to be "115, 116, 117" (I have manually written them in at the…
I am reaching out to seek your assistance regarding an issue I'm encountering while calculating the number of surveys completed on each day of the week (Monday-Sunday). Despite various attempts to identify the correct day of the week using functions like DAY, WEEKDAY, and DATEONLY, I am consistently facing discrepancies…
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
©2024. All Rights Reserved Smartsheet Inc.