Hello!
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?
Thanks!
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!