getting error in if else

[sonipradeep]

I have 2 dates Planned start date and planned end date ,  i want to find out the Project status as Completed, Inprogress, yet to start  depending on Today Date  if today date falls in between start and end date it should be in Progress,  if planned start date is less then today then it should Done. I am trying for in progress it giving me error as missing right parenthesis . trying  to make new column(Calculated field).

[jerryyang756]

Can you share the expression with dimension and measure details ?

[jyothish8807]

Hi Soni,

May be like this:

If(Today() >= Planned_St_Date and Today() <=Planned_end_date,'Inprogress',

if(Today() < Planned_St_Date,'Yet to start','Completed'))