Hi Maxime,
Getting triggers to work exactly how you need them can be a bit tricky. What I think is happening is that although the field trigger and sheet trigger work independently, they don't work in combination.
If you are keeping the tab row, then you need to have both types of trigger set up. If not then you can probably avoid the use of sheet triggers. The field trigger needs to also select the relevant salesman, like my earlier code. If you have different values for the salesman field depending on the sheet chosen, you will need to use an if statement, or I would use a pick/match combination (much easier to read than an 'if') like this ...
=pick(match(onglet,'RDV','Actions'),'Jon','Jack')
What this does is look at the value of onglet and match it against the listed values RDV and Actions returning 1 or 2 if there's a match and zero if none found. It then picks value 1 or 2 from the list of salesmen names and this can be applied to the field salesman.
Hope this helps
flipside
