Forum Discussion

PeterVE95's avatar
PeterVE95
New Member
2 years ago
Solved

How to return a different value if the reference cell is blank

Hello,

 

Looking for help to solve this issue.

My command is still returning "Overdue" when the Due Date column is blank. How can I only return Overdue if the Due Date is > Today?

 

 

Thank you

 

  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    Hi,

     

    You can try this

     

    OverdueStatus =
    IF(
    ISBLANK('YourTable'[Due Date]),
    BLANK(),
    IF(
    'YourTable'[Due Date] < TODAY(),
    "Overdue",
    BLANK()
    )
    )

2 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi,

     

    You can try this

     

    OverdueStatus =
    IF(
    ISBLANK('YourTable'[Due Date]),
    BLANK(),
    IF(
    'YourTable'[Due Date] < TODAY(),
    "Overdue",
    BLANK()
    )
    )