3 Replies Latest reply: Jun 14, 2016 5:36 AM by Gabor Tarnoczai RSS

    problem in converting excel formula into load editor

    lingling Guo

      Hi, i have problem in converting the excel formula into load editor,

       

       

        =IF(EXACT(G2,""),"Not Started", IF(H2<=TODAY(),"Completed",IF(G2<=TODAY(),"In-Progress_Start",IF(F2<=TODAY(),"In-Progress_Tender",IF(E2="","Not Started",IF(E2<=TODAY(),"In-Progress_PEP","Not Started"))))))

       

      Capture.PNG

       

      This is what i have try, but there is error

      IF("Start"=(''),('Not Started'),IF("End" =('<='TODAY()),('Completed'),IF("Start"=('<='TODAY()),('In-Progress_Start'),IF("Tender"=('<='TODAY()),('In-Progress_Tender'),IF("PEP"=(''),('Not Started'),IF("PEP"=('<='TODAY()),'(In-Progress_PEP'),('Not Started')))))) as "Status_try",


      Thanks in Advance:)