Forum Discussion
Dolphin_Loh
Sep 10, 2021Copper Contributor
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