Forum Discussion

batvan276's avatar
batvan276
Copper Contributor
Feb 22, 2021
Solved

Json Formatting Column Code

Hello, 

 

I wanted to use Json code to format a number column as a data bar. I found the resource to do this but before I can attempt this I need to learn how to use Json code to count the # of days since the Document was uploaded ( Created Column) to when the (Status) field is set to 'Resolved'. I need it to display in days. 

 

Can anyone help?

 

  • batvan276 

     

    You cannot track the changes to Status column & it's value using JSON code. Using JSON you can only customize how fields in SharePoint lists and libraries are displayed.

     

    You might want to populate the no. of days column based on status change using Power Automate flow and then you can apply formatting using JSON:

    Format a number column as a data bar 


    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.

  • batvan276 

     

    You cannot track the changes to Status column & it's value using JSON code. Using JSON you can only customize how fields in SharePoint lists and libraries are displayed.

     

    You might want to populate the no. of days column based on status change using Power Automate flow and then you can apply formatting using JSON:

    Format a number column as a data bar 


    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.

Resources