Strip thousands separator from Enum

[Izzat_Safrah]

To Strip thousands separator

1. Create Virtual Column names [YEAR_] Type Number

• App formula     =YEAR( [DATE] )
• From Type Details   Uncheck the box of show thousands separator

2. Create Virtual Column names  [YEAR] Type Enum

• App formula     =TEXT( [YEAR_] )

3. When we use View Type Table it will appear in Desktop Mode like this

-------------------------------------------------------

The reason for the Tricks

1. In order to display Format Rules in Desktop Mode with View Type Table, we need to use  Enum

2. If we use Enum with Base Type Number It doesn't remove the thousands separator

[dbaum]

If format rules don't work appropriately in the new desktop UI, I suggest you report that in the announcement about that feature: In Preview: New UI design for desktop users - Google Cloud Community.

[Izzat_Safrah]

@dbaum 

That's right, the format only works with the Enum in Desktop mode.

I will report that, Thank you.

[Izzat_Safrah]

This my report In Preview: New UI design for desktop users   LInk