Forum Discussion

speterson's avatar
speterson
Regular Visitor
5 years ago
Solved

calculating SLA help

Hi there, I need help with a situation - need a column that will calculate if something is still open AND past its due date   IF column1 AND column2 AND column3 are null AND it is after DUE_DATE...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi speterson ,

     

    Check the formula.

     

    Column = IF(ISBLANK('Table'[SLA CBO])&&ISBLANK('Table'[SLA Completed])&&ISBLANK('Table'[SLA Cancels]),IF(TODAY()>'Table'[Client Due Date],"Open - SLA Missed","Open - Within SLA"))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi speterson ,

 

Check the formula.

 

Column = IF(ISBLANK('Table'[SLA CBO])&&ISBLANK('Table'[SLA Completed])&&ISBLANK('Table'[SLA Cancels]),IF(TODAY()>'Table'[Client Due Date],"Open - SLA Missed","Open - Within SLA"))

 

Best Regards,

Jay