Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,)
missing brackets:
Only({<Position = {'Primary'}>} Salesperson)
hope this helps
regards
Marco
Did you try using Only(<Position = {'Primary'}>Salesperson)?
THis comes up as an invalid formula
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
Please upload a sample of your application.
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
missing brackets:
Only({<Position = {'Primary'}>} Salesperson)
hope this helps
regards
Marco
Excellent - this works perfectly.
Thanks.
You're welcome
Regards
Marco