Hi All,
I want to select a value on the basis of matching strings of field value selected to use in On Leave Sheet trigger.
Eg: If value 'Pump Factory' is selected in Company Name ,then the matching string should be used to select a value to use in the trigger.
The issue is ,in each sheet report the IDs with which the Company Name are linked is different in different sheets ,hence the Company Name selection is removed when changing sheets.
Company name values are similiar in all sheets and hence i want to select on condition of string matching .
I tried the following on On Leave sheet
if(match(Company Name),GetFieldSelections(CompanyName)),CompanyName)
on Select in Field action for Company Name field.
But it is not working,
What changes should i do?
Thanks in advance.