Forum Discussion
If calculated value column exceeds 24 hours
Hi! I got this calculated column that shows values of "hh:mm:ss". But i've noticed that if its exceeds 24:00:00 it will restarts to ex. 01:00:00.. Is there anywat to make a validation or form...
I'm kinda new to this, where in my code should I input this code?
Did like example below, doesnt work. Guess its all wrong
{
"$schema": "<a href="https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" target="_blank">https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json</a>",
"elmType": "div",
"attributes": {
"class": "=if(@currentField <= '02:00:00', 'sp-css-backgroundColor-successBackground50', if(@currentField >= '02:00:00', 'sp-css-backgroundColor-errorBackground50', '"
},
"children": [
{
"elmType": "span",
"style": {
"display": "inline-block",
"padding": "0 4px"
},
"attributes": {
"iconName": "=if(@currentField <= '02:00:00', 'CheckMark', if(@currentField >= '02:00:00', 'Warning', '"
}
},
{
"elmType": "span",
"txtContent": =@currentField > 24 ? 'Over 24 hours' : @currentField
}
]
}
Can you please try enclosing them in double quotes?
can you pls try below and post me the error message if you get any
"txtContent": ="@currentField > 24 ? 'Over 24 hours' : @currentField"It doesnt work...
Only shows like this:
I'm getting "Enter a valid JSON column formatting code" error.
"children": [ { "elmType": "span", "txtContent": ="@currentField > 24 ? 'Over 24 hours' : @currentField", "attributes": {}, "style": { "color": { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "00:00:00"Hi,
Thats a mistake in typo
"=if([$TimeField]==10,'Over 24','less than 24')" //assuming the TimeField is number or you can use @currentField='24:00:00'Not sure,if you are aware about thishttps://github.com/SharePoint/sp-dev-solutions/blob/master/solutions/ColumnFormatter/docs/documentation/docs/getting-started.mdyou can try with this in your workspace.
If I type like this I get error:
{ "elmType": "span", "txtContent": =@currentField > 24 ? "Over 24 hours" : @currentField }