Need help for creating Sharepoint List Calculated Column

%3CLINGO-SUB%20id%3D%22lingo-sub-2781912%22%20slang%3D%22en-US%22%3ENeed%20help%20for%20creating%20Sharepoint%20List%20Calculated%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2781912%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20a%20newbie%20and%20I%20have%20created%20a%20Sharepoint%20List%20basically%20to%20track%20tasks%20in%20a%20Sharepoint%20Online%20Site.%20I%20got%202%20date%20columns%20named%20as%20%22Due%20Date%20and%20Closed%20Date.%20Closed%20Date%20is%20populated%20once%20a%20user%20marks%20a%20task%20as%20completed%2C%20otherwise%20it's%20left%20blank.%20Trying%20to%20create%20a%20third%20calculated%20column%20named%20%22Delay%22%20that%20should%20return%20respective%20values%20when%20bellow%20conditions%20are%20met%3A%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E1.%20If%20Closed%20Date%20is%20equal%20or%20earlier%20than%20Due%20Date%2C%20value%20should%20be%20%22In-time%22%3C%2FP%3E%3CP%20class%3D%22%22%3E2.%20If%20Closed%20Date%20is%20later%20than%20Due%20Date%2C%20the%20value%20should%20be%20calculated%20as%20difference%20of%20number%20of%20days%20between%20Closed%20Date%20and%20Due%20Date%20(i.e.%203%20Days).%3C%2FP%3E%3CP%20class%3D%22%22%3E3.%20If%20Closed%20Date%20is%20null%2Fblank%20and%20today's%20date%20is%20equal%20or%20earlier%20than%20Due%20Date%20value%20should%20be%20%22In-time%22.%20This%20value%20should%20be%20updated%20depending%20on%20when%20the%20user%20is%20accessing%20the%20list.%3C%2FP%3E%3CP%20class%3D%22%22%3E4.%20If%20Closed%20Date%20is%20null%2Fblank%20and%20today's%20date%20is%20later%20than%20Due%20Date%20value%20should%20be%20calculated%20as%20difference%20of%20number%20of%20days%20between%20Due%20Date%20and%20today's%20date%20(i.e.%203%20Days).%20This%20value%20should%20be%20updated%20depending%20on%20when%20the%20user%20is%20accessing%20the%20list.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EAppreciate%20if%20anyone%20could%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2781912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECalculated%20Column%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

I'm a newbie and I have created a Sharepoint List basically to track tasks in a Sharepoint Online Site. I got 2 date columns named as "Due Date and Closed Date. Closed Date is populated once a user marks a task as completed, otherwise it's left blank. Trying to create a third calculated column named "Delay" that should return respective values when bellow conditions are met:

 

1. If Closed Date is equal or earlier than Due Date, value should be "In-time"

2. If Closed Date is later than Due Date, the value should be calculated as difference of number of days between Closed Date and Due Date (i.e. 3 Days).

3. If Closed Date is null/blank and today's date is equal or earlier than Due Date value should be "In-time". This value should be updated depending on when the user is accessing the list.

4. If Closed Date is null/blank and today's date is later than Due Date value should be calculated as difference of number of days between Due Date and today's date (i.e. 3 Days). This value should be updated depending on when the user is accessing the list.

 

Appreciate if anyone could help.

0 Replies