Ugly Date in If-then-else

My app’s URL:

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


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.


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?


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.


That worked!! Thanks!

1 Like