Dear Community,
Just wondering how to show the Date without the time in the Template, in which the data is from IF-Else-Then Formula. Any help would be much appreciated.
That’s a known issue with if-then-else columns. What you have to do is create another math column after the if-then-else column, and set the date format in that column.
How do I transpose the initial If-then-else value (date with time) to the new colume with date format? Which function should i use? I would like to do this in glidetable
In google sheet it is simply = .
Use a Math column with no formula. Just enter something like Date (for example), and replace Date with your if-then-else column. You can then format the Math column as Date Only, and use that in your template column.
Like this:
(That example isn’t using an if-then-else column, but the method is exactly the same).
1 Like
Awesome! Thanks!
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.