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!
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!
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.