Post

2 followers Follow
0
Avatar

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 Answered

Please sign in to leave a comment.

1 comment

0
Avatar

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 0 votes
Comment actions Permalink