Forum Discussion
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 which checks that IF the stagename is 'Bid Made' and the CloseDate is 'smaller then or the same as today' it wil get the value 'Te Laat' en otherwise it does nothing.
What am i doing wrong ?
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.
14 Replies
Change this operator "=<" to " <=".
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'
Try this:
mycolumn = SWITCH(TRUE(),
OR(Project [StageName]="Bid Made", Project[CloseDate] <=TODAY()), "Te laat","")
