Hello!
Now with the introduction of the Formula (HTML) field, HTML within a saved search result seems to only work with this type of field.
I'm currently trying to make a saved search where I can change the colour of the text based on the number, but I would like this number to be currency.
Currently, I can make it work using the Formula (HTML) field, but what bugs me is that the number formatting is not the same as using currency.
I need to do it through the text because the background colour uses a different criteria. For example, the row could be red, but this result could be green.
Is there a way where I can set the text colour but keeping the currency formatting? I'm currently using a CASE WHEN within a Formula (HTML) field, but I lose the currency formatting.
Thanks!