It seems that it is not possible to apply arrayformula on OR/AND operators, what do you think?
=ARRAYFORMULA(IF(OR(AND(BT4:BT100=“H”;BU4:BU100<O$11);AND(BT4:BT100=“D”;BU4:BU100<O$15));TRUE;FALSE))
Are you wanting to translate that to Glide Computed columns, or is it just not working in your Google Sheet?
Just in Google Sheets!
ah, I see.
The below might help:
Looks like you need to replace OR with +, and AND with * when used with IF
Thank you, it did not work by changing OR by + and AND by *. Do I have to make other changes? There is no + in the stackoverflow example.
Sorry, I can’t help any more.
If it was me, I’d just do it in Glide.
1 Like
Can you share a sample single sheet with some dummy data?
I just requested editing access. Thank you!
1 Like
Here you go, using the same method Darren mentioned (+ and *)
If you have any questions feel free to send them here.
3 Likes
@Darren_Murphy @ThinhDinh Thank you both for helping an old man 
!
/ Ralf 80
Here you can see it in use:
4 Likes
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.