How to skip blank cell

[Sander_NL]

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 · Accepted solution]

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]

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