Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
If i enter into the sheet by default certain should be select mode always.For that i have done like below
Sheet Properties---Triggers---select in field---
I have the field country and the values are below.
Austria
Benelux
Denmark
Dubai
Finland
France
Germany
Great Britain
Hungary
Italy
Norway
Pan-Europe (CP)
Poland
Portugal
Slovakia
South Africa
Spain
Sweden
Switzerland
I tried like below :
'(Austria|Benelux|Denmark|Dubai|Finland|France|Germany|Hungary|Italy|Norway|Poland|Portugal|Slovakia|Spain|Sweden|Switzerland|*South*|*Great*|*Pan*|*Senegal*)'
But its not working.I need to resolve this then i need to go ahead with further requirement.
More Thanks in advance,
Ajay
Hi ,
Any help or hint from anyone?
More Thanks,
Ajay
Sweden and Germany ?
Sweden and Denmark ?
for Sweden and Germany change the expression (bold)
if(count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)=0, 'DEVTEAM@xyz.com',
if(only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)=0, 'SALESTEAM@xyz.com',
the result I get is
Thanks Massimo.Your right...Its my mistake and sorry for convenience caused earlier.
One thing i want to know how =0 is working here?
What will happen if i kept <> 0 and if i remove the 0?
When am playing with original data with and without 0 am getting some wrong result.
More Thanks for your valueble support.
Ajay
if I understand
One thing i want to know how =0 is working here?
It works as a standard if: if(condition, then, else); condition could be true or false.
if(exp1=0,
'DEVTEAM@xyz.com', // exp1=0
if(exp2=0, // exp1 not = 0
'SALESTEAM@xyz.com', // exp2 = 0
'SUPPORTTEAM@xyz.com' // exp2 not = 0
)
)
exp1 is the result of the below expression (add a textbox with this expression to see the result of exp1)
=count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)
exp1 is the number of distinct country for max date and with country = Sweden or Germany
when exp1 is 0 --> DEVTEAM
if(0=0,
'DEVTEAM@xyz.com', // exp1=0
......