Forum Discussion

Iron Contributor

Aug 01, 2022

Solved

SP List Format Calculated Field

I have a calculated field called Total (data type is Currency) that counts the sum of some columns, formula is below and it works. =SUM([Aug-22],[Sept-22],[Oct-22]) I want to conditio...

Lists

SharePoint Online

ganeshsanap
Aug 01, 2022
jonboylib Try changing this line:

"txtContent": "@currentField"

to this:

"txtContent": "@currentField.displayValue"

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap

MVP

Aug 01, 2022

jonboylib Try changing this line:

"txtContent": "@currentField"

to this:

"txtContent": "@currentField.displayValue"

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

jonboylib

Iron Contributor

Aug 01, 2022

ganeshsanap Now the conditional colour formatting only works when I edit an item using 'edit in grid view'. As soon as I click 'exit grid view' the colour formatting is ignored.

ganeshsanap
MVP
Aug 01, 2022
jonboylib Can you try hard refresh (Ctrl + F5) after you click 'exit grid view'? Also, check if JSON formatting code is still there in column settings.
If still facing this issue, try clearing browser cache.
Please consider giving a Like if my post helped you in any way.
- jonboylib
  Iron Contributor
  Aug 01, 2022
  ganeshsanap I've tried a hard refresh, cleared cache, restarted the browser.. and the JSON is still appearing as below;