Forum Discussion

Dolphin_Loh's avatar
Dolphin_Loh
Copper Contributor
Sep 10, 2021

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

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.

 

{
"elmType": "div",
"txtContent": "= ' ' + 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": "= ' ' + floor((Number(@now)-Number([$CurrentApprovalStartDateandTime]))/(1000*60)) + ' min(s)'",
 "style": {
 "border": "none",
 "background-color": "transparent",
 "cursor": "pointer",
 "display": "=if([$AssignedTo]!='','flex','none')"
 }
 }

 

 

No RepliesBe the first to reply

Resources