Forum Discussion
Ainzo992
Sep 05, 2022Copper Contributor
Calculated field formula
Guys, I have this formula now: "style": { "color": "=if([$Modified] > [$Publicationdate], '#ff0000', '')", "font-weight": "=if([$Modified] > [$Publicationdate], 'bold', '')" } I want to...
- 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
Sep 05, 2022MVP
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.