Forum Discussion
Conditional formatting for dates based on another cell value
DWOps Use this JSON for your list view formatting:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json", "additionalRowClass": "=if([$Status] == 'Awaiting Payment', if(@now >= addDays([$DateBillSent],60),'sp-field-severity--severeWarning',if(@now > addDays([$DateBillSent],30) && @now < addDays([$DateBillSent],60),'sp-field-severity--warning50','')), '')" }Where Status and DateBillSent are internal names of your status and date columns. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?
Output:
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.
DWOps Use this JSON for your list view formatting:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if([$Status] == 'Awaiting Payment', if(@now >= addDays([$DateBillSent],60),'sp-field-severity--severeWarning',if(@now > addDays([$DateBillSent],30) && @now < addDays([$DateBillSent],60),'sp-field-severity--warning50','')), '')"
}
Where Status and DateBillSent are internal names of your status and date columns. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?
Output:
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 you're a star! perfect, thank you.
DWOps You are welcome, I am glad it worked for you.
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.
