Forum Discussion

Sander_NL's avatar
Sander_NL
Icon for Helper I rankHelper I
6 years ago
Solved

How to skip blank cell

Hi,

 

If no decomm date is filled in no value should be displayed in the status column.

 

Status = if(Test[Decomm date]<[CC1];"on time";"delayed")
 
Additional info: The planned end date is a calculated column: CC1 = 1*[Startdate]+14
 

 
  • az38's avatar
    az38
    6 years ago

    Hi Sander_NL 

    try

    Status = if(isblank(Test[Decomm date]);"no value";if(Test[Decomm date]<[CC1];"on time";"delayed"))

    if i understand you correct

    do not hesitate to give a kudo to useful posts and mark solutions as solution

2 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Sander_NL 

    try

    Status = if(isblank(Test[Decomm date]);"no value";if(Test[Decomm date]<[CC1];"on time";"delayed"))

    if i understand you correct

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • Sander_NL's avatar
      Sander_NL
      Icon for Helper I rankHelper I
      6 years ago

      Thanks az38. This works! Instead of no value I've changed it into "null" using blank.

       

      Status1 = if(isblank(Test[Decomm date]);BLANK();if(Test[Decomm date]<[CC1];"on time";"delayed"))