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 ...
  • 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

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