Forum Discussion

Copper Contributor

Jun 25, 2021

Solved

Sharepoint List Column Formatting

Hello everyone. I have a Sharepoint Online list with various different fields holding contract information. Each row contains several date fields formatted dd/mm/yyyy. I want every row that has an ex...

Lists

SharePoint Online

ganeshsanap

Jun 28, 2021

DevHuws Not sure if I understood it correctly. But, either of below JSON codes should work for you:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
   "additionalRowClass": "=if(([$DueDate] && [$DueDate] <= @now) || ([$EndDate] && [$EndDate] <= @now) || ([$AnyOtherDateColumn] && [$AnyOtherDateColumn] <= @now), 'sp-field-severity--severeWarning', '')"
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
   "additionalRowClass": "=if((Number([$DueDate]) !=0 && [$DueDate] <= @now) || (Number([$EndDate]) !=0 && [$EndDate] <= @now) || (Number([$AnyOtherDateColumn]) !=0 && [$AnyOtherDateColumn] <= @now), 'sp-field-severity--severeWarning', '')"
}

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.

DevHuws

Copper Contributor

Jun 28, 2021

Hi thanks for the quick reply. Sorry not sure if I explained properly, I don't mind the whole row being coloured I just dont want the row to be coloured if for example start date was empty, and only colour the row if it includes a date which has expired. If this is not possible I will use the example you have mentioned with column formatting. Thank you for your help!

ganeshsanap

MVP

Jun 28, 2021

DevHuws Not sure if I understood it correctly. But, either of below JSON codes should work for you:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
   "additionalRowClass": "=if(([$DueDate] && [$DueDate] <= @now) || ([$EndDate] && [$EndDate] <= @now) || ([$AnyOtherDateColumn] && [$AnyOtherDateColumn] <= @now), 'sp-field-severity--severeWarning', '')"
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
   "additionalRowClass": "=if((Number([$DueDate]) !=0 && [$DueDate] <= @now) || (Number([$EndDate]) !=0 && [$EndDate] <= @now) || (Number([$AnyOtherDateColumn]) !=0 && [$AnyOtherDateColumn] <= @now), 'sp-field-severity--severeWarning', '')"
}

J27
Copper Contributor
Sep 03, 2021
ganeshsanap,
Hi Ganesh,

I have a same scenario in Sharepoint where if column value is >0, then it need to be in red color. It's a calculated column like below
if([DueDate]-[ActivationDate]>28, "[Other column] * 1000", 0$). I don't want to do anything with this formula. Only color formatting need to be applied if column value >0, then red color.

Do you have any suggestions, please.

Regards
Janaa
- RobElliott
  Silver Contributor
  Sep 03, 2021
  J27 you just need to format the column as below, it doesn't matter that it's a calculated column.
  { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=[$Percent]*100 + '%'", "style": { "color": "=if([$Percent] > 0 , '#80000d', '#3b3b3b'" } }
  
  Rob
  Los Gallardos
  Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
  - J27
    Copper Contributor
    Sep 03, 2021
    RobElliott
    
    Could you please let me know, do I need to change the $Percent to my column. Above code doesn't works for me when I pasted this in JSON Column Formatting area.
    
    Thanks for your time.
    
    Regards
    Janaa