How to create a formula for the requirements below ?

I have a custom field with a data type of Pick List which consists of 3 options which are "On Track","Off Track","Completed".

How can I create a formula such that :-
IF DueDate > 7 days SELECT "OFF TRACK"
IF DueDate IS NOT DUE SELECT "ON TRACK"

Thanks!

KH UEM February 16, 2017 02:38 Answered

Please sign in to leave a comment.

Hi,

Please try to use the following formula:

If( DateDiff($DueDate ,Today(),"d") >7, "OFF TRACK","ON TRACK")

Let me know if you have any further questions.

Bea

Bea Genthner February 16, 2017 15:52 0 votes