Hi so I'm trying to pull a value into a spreadsheet based on the date being older than today. I've attached the top of the table and the first row below it. So what I'm trying to do is return the JO# column as long as the Production Due date is older than today. I need to pull all late orders into it's own sheet based off data that I refresh daily. So what I'm trying to do without success is
=LOOKUP(Table_owssvr[@[JO'#]], IF(Table_owssvr[@[Production Due]],"<"&TODAY()))
. I'm hoping someone will be able to help me with this. Thanks in advance!JO# | SO# | Customer | Expedite | Dock Date | Kanban Order | Current Status | Requested | Production Due | Ship Date | Part Number | Rev | QTY | Notes | Owner | Special Instructions | Receipt Info | Item Type | Path |
TS-000684 | 1000514 | N/A | FALSE | 12/25/2026 | FALSE | In-Process Cell HV | 12/25/2026 | 1/13/2020 | 1/14/2020 | TS-520 | 3 | C101134-LE2 | Item | Lists/JO List |
Last edited by a moderator: