Jan 10 2023 04:26 PM
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 datedif function together with 'TODAY', but it does not work. I guess I need to have an additional column with today's date to use this one? Was hoping to create it using workflows but these were retired in SharePoint 365. Is there a way to do it differently?
Would much appreciate your help.
Jan 10 2023 11:28 PM - edited Jan 10 2023 11:29 PM
@kobi1991
You could apply JSON Formatting:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=floor((Number(@currentField)-Number(Date((getMonth(@now)+1)+'.'+getDate(@now)+'.'+getYear(@now))))/(60*60*24*1000))+' day(s) remaining'"
}
Best Regards,
Sven
Jan 11 2023 02:55 AM
Thank you, Sven! Apologies but I'm completely new at this - could you please explain where in the code I should put my 'due date' column?
Karolina
Jan 11 2023 03:05 AM
SolutionHi @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
Jan 11 2023 08:20 AM
Jan 11 2023 08:30 AM
Hi @kobi1991
You could create a calculated column "Countdown" of type "Date" with the formula
=[Due Date]
and then apply the formatting there.
Then you have two columns with the same value, but one is displaying the date and the other one is displaying the countdown.
Best Regards,
Sven