If(vbg7 = 'G' and vBG6 <> 'G', vBG6, vbg7)
with above formula I'm still getting 'G' instead of 'R', what mistake I'm making?
Getting R, here
May be share your app
If(vbg7 = 'G' and vBG6 <> 'G', 1,2)
Do you get one or two
Copy this to script
Set vbg7='G'; Set vBG6='R';
now in textbox add
=If(vbg7 = 'G' and vBG6 <> 'G', vBG6, vbg7)
I appreciate your help, btw in my case vbg7 needed to evaluate ($(vbg7)) first.
Thanking you all of you for your valuable time
Retrieving data ...