Help Plz

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()

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.