Forum Discussion

kobi1991

Copper Contributor

Jan 11, 2023

Countdown to due date in SharePoint 365 list

Hello! I'm using a SharePoint 365 list as an action tracker. My list contains the due date. I would like to add a column that contains a count of days remaining to the due date. I tried the ...

Lists

SharePoint Online

Sites

SvenSieverding
Jan 11, 2023
Hi kobi1991 ,

sure. This is SharePoint Json list formatting code that formats a column.

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

Got to you SharePoint View, select the header of your "Due Date" column and select "Column Settings->Format this Column"

Copy the Json Code here

You don't have to change the formula, as "@currentField" references to the selected Column.

Best Regards,
Sven

faric1311

Copper Contributor

Jun 22, 2023

Hi SvenSieverding,

I have a question about your json code, i have tried to apply the code into my list but all the dates that have past due displays for example "-29 days", is there any code that could make all the dates that have past due displays "0 days"

Thanks

Best Regards,

Faric

SvenSieverding

Bronze Contributor

Jun 22, 2023

Hi faric1311,

in that case you can just wrap it into an if clause.
This displays the remaining days, if the calculated value is larger than 0 and "no days remaining" if that value is below or equal 0.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(floor((Number(@currentField)-Number(Date((getMonth(@now)+1)+'.'+getDate(@now)+'.'+getYear(@now))))/(60*60*24*1000))>0,floor((Number(@currentField)-Number(Date((getMonth(@now)+1)+'.'+getDate(@now)+'.'+getYear(@now))))/(60*60*24*1000))+' day(s) remaining','no days remaining')"
}

Best Regards,
Sven

Chawoo
Copper Contributor
Aug 15, 2023
Hi Sven!

I am having a similar issue getting 2 columns in Microsoft Lists - I was hoping to have column A list a date that I manually type in, and column B present a countdown until that date.

I was having issues modifying the information you provided to match my Lists, would you happen to have any insight?

Kindly,
Chase
- SvenSieverding
  Bronze Contributor
  Aug 16, 2023
  Hi Chawoo,
  
  sure.
  @currentField
  refers to the column where the format is applied on. But you can refer other columns by their internal Name.
  Given you have the column "Other Date Column" then you reference that as "[$OtherDateColumn]", so the formula becomes this
  
  { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(floor((Number([$OtherDateColumn])-Number(Date((getMonth(@now)+1)+'.'+getDate(@now)+'.'+getYear(@now))))/(60*60*24*1000))>0,floor((Number([$OtherDateColumn])-Number(Date((getMonth(@now)+1)+'.'+getDate(@now)+'.'+getYear(@now))))/(60*60*24*1000))+' day(s) remaining','no days remaining')" }
  Now apply that to your other (Countdown) column.
  
  Best Regards,
  Sven
  - bcbbcb
    Copper Contributor
    Aug 29, 2023
    SvenSieverding Is it possible to leverage this same approach but list days and hours, as opposed to just days? Appreciate your advice.