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...
Need Help
  • RvdHeijden's avatar
    RvdHeijden
    9 years ago

    Anonymous

    What I mean by no success is that the formula now returns 300 rows al with the value 'Te laat' and all have the stagename 'Bid Made' so that part works.

    However if i check the closedate on these 300 rows the date doesn't match because there are rows in the result with the date of 25th of oktober and beyond.

     

    So there is something wrong with the second part of the formula

     

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

  • Anonymous's avatar
    Anonymous
    9 years ago

    There's nothing wrong with that formula. Are you sure the date column you're checking is properly formatted as a date? If your system and that column disagree about date-month order it could be reading those dates incorrectly. Either that or those dates later than October 25th are in a different year and you didn't notice.

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago

Anonymous

What I mean by no success is that the formula now returns 300 rows al with the value 'Te laat' and all have the stagename 'Bid Made' so that part works.

However if i check the closedate on these 300 rows the date doesn't match because there are rows in the result with the date of 25th of oktober and beyond.

 

So there is something wrong with the second part of the formula

 

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

Sean's avatar
Sean
Community Champion
9 years ago

RvdHeijden One thing to consider that would pass the condition in the formula is a blank CloseDate! 

 

But you should not be getting any dates after today to pass (see picture)

 

Column = 
IF (
    Project[StageName] = "Bid Made" && Project[CloseDate] <= TODAY (),
    "Yes",
    BLANK ()
)

Column 2 = 
SWITCH (
    TRUE (),
    ISBLANK ( Project[CloseDate] ), BLANK (),
    Project[StageName] = "Bid Made" && Project[CloseDate] <= TODAY (), "Yes",
    BLANK ()
)