‘Formatted as’ turns numbers and dates into text?

Questions
1

As soon as you use “Formatted as” it turns my number and/or dates into text type. Is there a way to format numbers with commas for thousands without it turning into text?

My data appears as: 123456789 as a number. I want it to read as $123,456,789 without turning it into text because I need my table to be able to sort by date or from least to greatest/ vice versa which are distinctly different from alphabetical sorting.

Any suggestions?

2

Hey Kevin,

Save the data as a number or date to the database. Then you can use ‘:formatted as’ anywhere you want to display the values on the front end with no impact to underlying data.

2 Likes