Hi, I’m looking for help - is it possible to use any of the native math functions to separate the date or time from a date/time column ?
Yes, just create create a math column, type in a value, such as ‘X’, then replace it with the date column you want to use. Then set the the format to be date only or time only.
2 Likes
Thanks for the reply Jeff. The problem I’m facing is relating two of these columns in different sheets as they seem to retain the date/time part and don’t match.
Any workarounds without using gsheets?
Create a template columns of the date or math column and use that for your relation. Templates will “lock in” the formatting you set on the date/math column and not use the underlying date value anymore.
2 Likes
Great stuff! cheers
1 Like