akmaximo83
New Member
Dear all,
I want weekly report based on data. One sheet consist of data and the other sheet consists of report.
I want to pull data datewise open and close WOs.
For service - Electrical date is 21/10/2023 if Status is not COMP THEN WOs will be open based on report date. ( match servicw with report service)
2. if status is comp then date in weekly report match with actfinish then WOs to be deemed closed.
can any body assist me or write formulas.
File Attached Here.
I want weekly report based on data. One sheet consist of data and the other sheet consists of report.
I want to pull data datewise open and close WOs.
For service - Electrical date is 21/10/2023 if Status is not COMP THEN WOs will be open based on report date. ( match servicw with report service)
2. if status is comp then date in weekly report match with actfinish then WOs to be deemed closed.
can any body assist me or write formulas.
File Attached Here.