Forum Discussion
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.
Try this:
mycolumn = SWITCH(TRUE(),
OR(Project [StageName]="Bid Made", Project[CloseDate] <=TODAY()), "Te laat","")
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.'
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";"")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 ?
That's not the way you've written the formula. You used OR, meaning that if either one of the two conditions is met it evaluates as true. For what you're describing now you would have to use AND.