Feb 06 2022 05:18 PM
I want to make new column based on the data in picture. There are 3 columns which are R, Y and B. If 2 of the 3 columns Yellow, or 1 of the 3 columns Red will label as "Priority 1". If 1 of the column Yellow but rest are green, will label as "No Action"... Other than that will "Priority 2". Can you guys guide me on this. Thank you.
Feb 06 2022 07:15 PM
Feb 07 2022 12:12 AM
Yes. The new column will be next to column B. So, if 2 of the 3 columns (R,Y,B) is above 50, then at new column will display "Priority 1". Also, if one of the 3 columns (R,Y,B) above 500, the new column will also display "Priority 1". Then, if 3 columns (R,Y,B) less than 50 or only one of the column is greater than 50 but lower than 150 and the rest green, it will display "No Action". Other than what I have stated before, will display "Priority 2".@mtarler
Feb 07 2022 05:53 AM
SolutionFeb 07 2022 05:53 AM
Solution