🤔How to: Stop and IF THEN ELSE column from showing the time (w/ pic)


My If then Else column IS working, however it displays the time despite none of the other factors being set to date AND time.

How can i work around this?


It’s showing the raw underlying value of the date column. Create a template column with a value such as ‘X’ and replace ‘X’ with your date column value. That will “lock it in” as a text string.

Or, a better solution would be to try adding a math column, which takes the result from the IF column and reformats it.

Thank you! This worked! Much appreciated!

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.