Date Format Effect after addition scenarios in If-Else Column

Dear Community,

I am not sure the reason why the Data format is affected when adding another scenario.

Before:

After Adding:

  1. All the dates are set as Medium showing dates only (throughout the app)
  2. How can we assure that the format be constant?

Thanks in advance.

It’s a known issue.

The workaround is to add a math column after the if-then-else column, and use that to reset the format.

You don’t need a formula in the math column, just enter something like D, and replace that with the if-then-else column value.

Awesome! Thanks for the tips!!

Can template works the same?

Btw, with so many additional columns just to get the effect, will overall performance (speed) be affected?

No, a template won’t work in this case. Try it and you’ll see what happens :wink:

Generally, no.
It just depends. There can be extreme cases where computed columns can contribute to poor performance. But as a general rule, it’s not something that you need to worry about. I have apps with thousands of computed columns, and they perform just fine.

1 Like

Thanks for your advice! Appreciate!

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