Forum Discussion

Maz_0102's avatar
Maz_0102
Helper I
4 years ago

IF Function on dates to change status

Hi

 

I am trying to create a column using the below if fuction

 

however i cant get the rows set to in progress

 

if the due date > today's date i want it returned to "In Progress"

 

Am i doing the formula wrong?

 

Column = IF('PPM''s'[Open Days from/to Due Date Status]="Complete",IF('PPM''s'[Job_Finish_Date]>'PPM''s'[Job_Due_Date],"Complete - Late",IF('PPM''s'[Job_Finish_Date]<='PPM''s'[Job_Due_Date],"Complete - On Time",IF('PPM''s'[Job_Due_Date] > 'PPM''s'[Today's date],"In Progress",""))))
Need Help
Tips and Tricks

1 Reply

  • ManguilibeKAO's avatar
    ManguilibeKAO
    Resolver I
    4 years ago

    Hi,

     

    Could we have input data (or at least four or five rows in the input), and the output you want?

     

    Best regards.