Forum Discussion

Ainzo992's avatar
Ainzo992
Copper Contributor
Sep 05, 2022

Calculated field formula

Guys,

 

I have this formula now: 

"style": {
"color": "=if([$Modified] > [$Publicationdate], '#ff0000', '')",
"font-weight": "=if([$Modified] > [$Publicationdate], 'bold', '')"
}
 
I want to add 15 minutes to publicationdate, so it should be modiefied + publicationdate+15 minutes 
How can i achieve this?
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Sep 05, 2022

    Ainzo992 You can use addMinutes() operator to add minutes to date. Try using expressions in this format: 

     

    "style": {
    "color": "=if([$Modified] > addMinutes([$Publicationdate], 15), '#ff0000', '')",
    "font-weight": "=if([$Modified] > addMinutes([$Publicationdate], 15), 'bold', '')"
}

     

    Documentation: json-formatting-syntax-reference  

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Sep 05, 2022

    Ainzo992 You can use addMinutes() operator to add minutes to date. Try using expressions in this format: 

     

    "style": {
    "color": "=if([$Modified] > addMinutes([$Publicationdate], 15), '#ff0000', '')",
    "font-weight": "=if([$Modified] > addMinutes([$Publicationdate], 15), 'bold', '')"
}

     

    Documentation: json-formatting-syntax-reference  

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources