I’m using query function in sheet(consultations) to bring all rows from sheet(cases list) that have either of these criteria
1- If column Q (disposition) is “consultation”
2- If Column Q (disposition) is “admission” AND column S is not empty.
But I want the column S from the master sheet (cases list) to be copied to column R in consultation sheet if criteria 2 is matched.
I used this formula but I couldn’t modify
=query(CASES,"select C,E,F,G,H,I,J,K,L,P,R,S where Q = 'Consultation' OR Q='Admission' AND S<>'' order by R ASC",0)
Note: I renamed data range of cases list sheet as “CASES”.