This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Hello!
I've created a column for 'Net Weight (oz)'. When the user enters oz, another calculated column returns lbs. I've successfully created the calculated column for lbs titled, 'Net Weight (lb)'. With the returned value in lbs, I would like to add "lbs" as the unit of measure for that column. I'm unsure of how to do this using JSON? When i add text content in JSON, the calculated value disappears.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "g"
}
Nevermind. Disregard. SharePoint question lol. Sorry to intrude.
I'm formatting the calculated column through advanced settings. Thats the problem. I don't know how to code in JSON. From my description, I would like to a code that adds text to the already calculated value.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField","lbs"
}
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Hi @Ramey, Micah ,
Haven't heard from you yet, we'd love to know if this issue has been resolved? , did you take the time to try the answers below?
You’re in luck, because I do know JSON. I looked at your example and I believe the following is what you need to properly combine the text together.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "= @currentField + ' lbs'"
}
Hi @Ramey, Micah ,
Have you tried what @Ed Harris offers?
Has the problem been resolved?
If you still have any confusion about this issue, you can contact us at any time. :)
Hi @Ramey, Micah , I’m checking how the things are going on about this issue. Have you got help from the answer? If there is any problem with this issue, feel free to let me know.
Hi @Ramey, Micah ,
I have tried the solution @Ed Harris offers, and it worked fine.
Could you please share the situation after you try it?
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.