Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago
Solved

Help Plz

Im searching for the correction of this formula   Column = IF(Project[StageName]="Bid Made" || Project[CloseDate]=< today();"Te laat"; "")   What im trying 2 do is to have a calculated column whi...
RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago

BhaveshPatel

i changed the operator and it works

 

Check = IF(Project[StageName]="Bid Made" || Project[CloseDate]<= today();"Te laat"; "")

 

However i didn't get the result i wanted because when i check the outcome it almost always says 'te laat' however it also reads 'te laat' for the rows that doesn't have the StageName 'Bid Made', somhow the formula ignores the first part of the formula which states that the StageName should be Bid Made otherwise it shouldn't do anything

 

Im not sure where it goes wrong but the formula should check that IF the stagename is not 'Bid Made' it shouldn't do anything but if it does read 'Bid Made' and the Close Date is today or the past ( < = ) then it should read 'te laat'

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Try this:

 

mycolumn = SWITCH(TRUE(),
OR(Project [StageName]="Bid Made", Project[CloseDate] <=TODAY()), "Te laat","")

 

 

  • RvdHeijden's avatar
    RvdHeijden
    Post Prodigy
    9 years ago

    BhaveshPatel

    Almost there i think.

     

    My formule is this:

     

    Column = SWITCH(TRUE();
       OR(PROJECT[StageName]="Bid Made"; Project[CloseDate] <=TODAY(); "Te laat";"")

     

    However the error states that 'The end of the imput was reached.'

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      RvdHeijden you're missing a close parenthesis after TODAY().

       

      Column = SWITCH(TRUE();
         OR(PROJECT[StageName]="Bid Made"; Project[CloseDate] <=TODAY()); "Te laat";"")

       

      Anyway there's no reason to use SWITCH if there's only one condition check. An IF statement would work fine and be easier to write.

       

      Column = IF(
         OR(PROJECT[StageName]="Bid Made"; Project[CloseDate] <=TODAY()); "Te laat";"")

      • RvdHeijden's avatar
        RvdHeijden
        Post Prodigy
        9 years ago

        Anonymous

        Both formulas give the same result and both aren't working properly.

         

        The formula begins that IF the StageName is 'Bit Made' then it should check the close date. However this formule seems to ignore the first part of the formula.

         

        I have the tekst 'Te laat' on rows with the status 'Order' or 'Order withdrawn' and that is strange seeing the formula should only do something IF the value is 'Bit made' so how come it works on other values ?