Hi guys, how are you ? I have a question regarding my table.
1-st task :
I want add IF or IFS formula to automate status in my columns.
A1 and B1 is most important columns and trigger with IF or IFS should be there. C1 and D1 is just info. E1 is most important tool because i want see status in short version as YES, NO, REJ or N/A.
=IFS( IF A1 have a date and b2 blank then NO ) (IF A1 blank then N/A ) ( IF A1 have date and ACC then YES ) ( IF A1 have date and REJ then REJ ) Something like this???
Thank you.
1-st task :
I want add IF or IFS formula to automate status in my columns.
A1 and B1 is most important columns and trigger with IF or IFS should be there. C1 and D1 is just info. E1 is most important tool because i want see status in short version as YES, NO, REJ or N/A.
=IFS( IF A1 have a date and b2 blank then NO ) (IF A1 blank then N/A ) ( IF A1 have date and ACC then YES ) ( IF A1 have date and REJ then REJ ) Something like this???
AF-099-QF-199 Welding Log (03.05.2021).xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | HT REQUEST DATE | HT RESULT | HT DATE | HT REPORT № | HT COMPLITED | ||
2 | 18.02.2021 | ACC | 18.02.2021 | SHT-1447 | YES | ||
3 | 18.02.2021 | ACC | 20.02.2021 | SHT-1500 | YES | ||
4 | 01.05.2021 | NO | |||||
5 | 01.05.2021 | NO | |||||
6 | 18.02.2021 | REJ | 26.02.2021 | SHT-1515 | REJ | ||
7 | N/A | ||||||
8 | N/A | ||||||
9 | N/A | ||||||
10 | N/A | ||||||
11 | N/A | ||||||
12 | N/A | ||||||
Sheet2 |
Thank you.