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
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
......
Hi ajay
you don't need the quotes, just (Austria|Benelux|Denmark) , gives:
HTH
Andy
if you have some space
("Austria"|"Italy"|"Great Britain")
You create a mapping field for these countries and take that Mapping field in your trigger
Sheet Properties ---> Triggers----- > select in field --- > Field = GrpCountry , search string = 'Group'
Country | GrpCountry |
Austria | Group |
Benelux | Group |
Denmark | Group |
Dubai | Group |
Finland | Group |
France | Group |
Germany | Group |
Great Britain | |
Hungary | Group |
Italy | Group |
Norway | Group |
Pan-Europe (CP) | |
Poland | Group |
Portugal | Group |
Slovakia | Group |
South Africa | Group |
Spain | Group |
Sweden | Group |
Switzerland | Group |
Hope this help.
Thanks Massiomo.Its working fine.
In addition with that i have the below scenario need to develop.
Condition 1 : If the Country not contains SWEDEN and DENMARK then mail should go to DEVTEAM@xyz.com
Condtion 2 : If FLAG =0 then the mail to go SALESTEAM@xyz.com
Condition 3 : If above two cases failed then SUPPORT@xyz.com
NOTE 1 : ALL the above conditions based on the MAX DATE selection.
2: Here i choosen select all option in triggers because to show all countries data in the straight table.
WHAT I TRIED :
= if(not wildmatch(Country,'Sweden','Germany'),'DEVTEAM@xyz.com',
if(flag=0,'SALESTEAM@xyz.com','SUPPORTTEAM@xyz.com'))
Please correct me where am wrong and also guide if in case its better to create a new thread.
MORE THANKS,
AJAY
I think the 2 expressions are
number of country Sweden or Germany (for max date); it should be 0 for not Germany and not Sweden
count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)
value of the flag (for max date)
= only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)
EDIT: new thread?
yes, I think 1 thread, 1 question (maybe with a link to this) or for many questions, all questions at the start of discussion
Hi Massimo,
I dont want to do any count or sum...whatever the conditions 3 i need to combine at one level like if else.
As per the selection and condition satifisfaction data to be display in text box like whether its devteam or supportteam or salesteam.
thanks,
Ajay
=
if(count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Denmark}>} distinct Country)=0, 'DEVTEAM@xyz.com',
if(only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)=0, 'SALESTEAM@xyz.com',
Thanks you.
I will try to apply the above logic with my original data scenario and will mark the thread.
Thanks,
AJAY
Hi Massimo...No luck its not working.
The same has been attached here.
Need help in the sample also my requirement is there.
More Thanks,
Ajay