Sharepoint Microsoft Lists, the column Approval pending since didn't appear the time in mins.

Regular Visitor

Hi to all

 

Not sure who can help me to pinpoint where i have miss out or do wrong.

 

below is the screenshot of the lists.

Dolphin_Loh_0-1631266145255.png

 

{
"elmType": "div",
"txtContent": "= ':stopwatch: ' + floor((Number(@now)-Number([$Modified]))/(1000*60)) + ' min(s)'",
"style": {
"border": "none",
"background-color": "transparent",
"cursor": "pointer",
"display": "=if([$AssignedTo]!='','flex','none')"
}
}
 
The above is i modifed  Json according to my lists column i have.
 
the below one is share by Youtuber Reza Doraani.
 
{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
 "elmType": "div",
 "txtContent": "= ':stopwatch: ' + floor((Number(@now)-Number([$CurrentApprovalStartDateandTime]))/(1000*60)) + ' min(s)'",
 "style": {
 "border": "none",
 "background-color": "transparent",
 "cursor": "pointer",
 "display": "=if([$AssignedTo]!='','flex','none')"
 }
 }

 

 

0 Replies