Ugly Date in If-then-else

My app’s URL: checkout.glideapp.io

I have an app for checking out shared devices. I want to display a date in the log beneath each item. That date will either be the checkout date (if checked out) or the check in date (if checked in). When I create this logic in the if-then-else column, the resulting date/time is the ugly format. The actual date time columns are pretty and I attempted to format my sheet columns as pretty versions without luck.

Screen Shot 2020-05-24 at 9.21.16 PM

Screen Shot 2020-05-24 at 9.21.47 PM

2 Likes

I think I’ve seen the same issue with already formatted numbers and had to create a follow-up math column just to get it to format with the proper precision and dollar sign.

Hello,

I just ran into this exact issue. The IF THEN ELSE formula is not displaying the same date time format as the input columns. Did you find a solution?

Thanks!

Usually creating a template column of the date column will “lock in” that formatting. Then you can use the template column in your if then column.

2 Likes

That worked!! Thanks!

1 Like