Better formula statement than if for picking value

[#1]

Is there a better statement than using if to select/display a value

I have data in rows like this:

Salesperson     Position

Joe                    Primary

Mary                    Split

I am using a text field to display the "Primary" salesperson.    Is there a better formula/statement than

if(Position='Primary',Salesperson,)

[srchilukoori]

Did you try using Only(<Position = {'Primary'}>Salesperson)?

[#3]

THis comes up as an invalid formula

[#4]

I used

pick(match(Position,'Primary'), 'Salesperson') and the above "IF" statement.  Both return the value I want.   The problem is, it only returns the value if i pick "Primary" in a list box.  

I want this field to ALWAYS display the primary salesperson

[srchilukoori]

Please upload a sample of your application.

[MarcoWedel]

Hi,

to let the primary salesperson be displayed regardless of any selections, you could use this expression:

=Only({1<Position={'Primary'}>} Salesperson)

hope this helps

regards

Marco

[MarcoWedel · Accepted solution]

missing brackets:

Only({<Position = {'Primary'}>} Salesperson)

hope this helps

regards

Marco

[#8]

Excellent - this works perfectly.

Thanks.

[MarcoWedel]

You're welcome

Regards

Marco