Forum Discussion

ZachUnger's avatar
ZachUnger
Helper II
2 years ago

Overdue based on multiple Columns

Morning Team  I'm working on a report that I need to show overdue but based on criteria from multiple columns.    Overdue is currently just based on Required by and today's date  Overdue = IF('*...
Need Help
Show and Tell
Tips and Tricks
PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

Hi ZachUnger 

 

I'm not entirely sure I follow the logic, it'd be best to provide a table with the actual results you want.  I'm not sure if the table you've provided is what you want or what you currently have.

 

From what you've written I understand that if Date Info Sent contains a date then it's not overdue.  Is this for all rows regardless of any other data like Extended To ?

 

Given that all the dates in your data are in 2023, and there's no column to show when something was delivered, aren't they all overdue?  Based on today's date?

 

Regards

 

Phil

 

  • ZachUnger's avatar
    ZachUnger
    Helper II
    2 years ago

    Thanks Phil 

    Hoping this table helps and you are able to view it larger but the text in red is the result I'm hoping for in the overdue column. 

    Cheers 

    Zach