Ratings with Currency Denotation Symbols (eg $, $$, $$$)

There are times where I’d like to indicate the expense or cost of any given object in my table with a one-to-five rating using a symbol indicating currency. For example, oftentimes restaurant meals are rating based on cost:€ for inexpensive, but € € € € € for very, very expensive.

Presently, my options are only flags, stars and thumbs-up signs. I’d like at least a $ option, but € and £ and perhaps other popular currency symbols could be used. It could be automatically set based on localization settings.

That would be a fun feature.

In the meantime, you can simulate this behavior by creating a formula field using the REPT function.

In your rating field, choose the number of stars/flags/thumbs, and then in your formula field, you can convert those symbols to the currency symbol that you want like this:

IF({Rating Field},REPT("$", {Rating Field}))

3 Likes