SharePoint Online View Conditional Formatting - Cannot create a rule with a Currency field

Question

I am trying to format a SharePoint Online view that contains a currency field (Cost) that does not show up in the dropdown when trying to create the rule. If I change the type to Single line of Text it will then be listed in the Dropdown. Is this a bug or are you not allowed to create a rule with a currency field? It does not seem to matter what other fields are in the list or view and I am only seeing this for currency fields.

Answer 1

Hi @Gorges, Shannon,

Thank you for posting in this community.

Based on the description of your question, I tested and found that indeed View Conditional Formatting doesn't support creating rules on Currency field.

Currency columns do not support JSON formatting. If you want to use JSON for the currency column you will need to create custom JSON schema to achieve your requirement.

The method described above is a bit more complicated. If it is convenient, I would prefer that you use a number column instead of a currency column. Number columns can be better applied to JSON formatting.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Gorges, Shannon,

Thank you for your reply.

After referring to this article (New Feature - SharePoint Online Column Formatting using JSON - Currency Columns), we can conclude that the currency column supports the column format though. However, due to the currency symbol in front of it, the whole value will be treated as a string and we can't make any judgment like “>”, "=" or "<".

Please accept my sincerely apologizes for any inconvenience this may cause. Thank you for your kind understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.