Date Format Effect after addition scenarios in If-Else Column

[ichilddev]

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.

[Darren_Murphy]

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.

[ichilddev]

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?

[Darren_Murphy]

@ichilddev

Can template works the same?

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

@ichilddev

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

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.

[ichilddev]

Thanks for your advice! Appreciate!