Hi Guys ?, I have a question to you about which formula can help me to show and collect all backlog in my Register.
I will add two Mini Sheets to describe everything in a simple way.
Note about trigger:
The trigger should be activated only in one condition when I have request Date only and No Result.
Example:
and show all info about this line in sheet 2 ↓↓↓↓↓↓↓
1)In first sheet I have 3 green position(1,2,3) which ok and fully completed ( no backlog)
2) Also I have some preference with completed Backlog in Sheet 2. In sort about process. At work I have 3 different departments which provide me with tests.
And if Backlog in Sheet 2 can show me Backlog by Test Type it will be good and more useful for me.
Example :
If it is note possible fore you then ok. It is acceptable in this way and I try separate by filter every time.
Thank you guys for your help and your time, I appreciate it .
?
I will add two Mini Sheets to describe everything in a simple way.
Note about trigger:
The trigger should be activated only in one condition when I have request Date only and No Result.
Example:
1)In first sheet I have 3 green position(1,2,3) which ok and fully completed ( no backlog)
| LINE LIST.xlsx | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 1 | Sheet 1 | ||||||||||||||||
| 2 | No | Name | Type | Date | Colour | Code 1 | Code 2 | Inspection | Test Type 1 Reques Date | Result of Test 1 | Test Type2 Reques Date | Result of Test 2 | Test Type 3 Reques Date | Result of Test 3 | |||
| 3 | 1 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | ACC | |||||||
| 4 | 2 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | ACC | 02.01.2021 | ACC | |||||
| 5 | 3 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | ACC | 02.01.2021 | ACC | |||||
| 6 | 4 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | 02.01.2021 | |||||||
| 7 | 5 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | ||||||||
| 8 | 6 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | ||||||||
| 9 | 7 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | |||||||||
| 10 | 8 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | |||||||||
| 11 | 9 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | |||||||||
| 12 | 10 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | |||||||||
| 13 | |||||||||||||||||
| 14 | |||||||||||||||||
Sheet1 | |||||||||||||||||
2) Also I have some preference with completed Backlog in Sheet 2. In sort about process. At work I have 3 different departments which provide me with tests.
And if Backlog in Sheet 2 can show me Backlog by Test Type it will be good and more useful for me.
Example :
If it is note possible fore you then ok. It is acceptable in this way and I try separate by filter every time.
| LINE LIST.xlsx | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 1 | Sheet 2 | ||||||||||||||||
| 2 | No | Name | Type | Date | Colour | Code 1 | Code 2 | Inspection | Test Type 1 Reques Date | Result of Test 1 | Test Type2 Reques Date | Result of Test 2 | Test Type 3 Reques Date | Result of Test 3 | |||
| 3 | 4 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | 02.01.2021 | |||||||
| 4 | 5 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | ||||||||
| 5 | 6 | Apple | Round | 01.01.2021 | Red | 5689731 | 215468 | 02.01.2021 | 02.01.2021 | ||||||||
| 6 | |||||||||||||||||
| 7 | |||||||||||||||||
Sheet2 | |||||||||||||||||
Thank you guys for your help and your time, I appreciate it .
?
