Hello SF Community,
I have a formula question... I have created the following validation rule on the Opportunity Products to restrict Users from adjusting the Sales Price below what is permitted when adding Products for an Opportunity:
OR(
AND( Product2.Name = "Band 1", UnitPrice < 7500),
AND( Product2.Name = "Band 2", UnitPrice < 8400)
)
What do I need to add to have this only trigger for Products with USD currency?
I'm assuming an IF formula needs to be created, but I can't seem to get it right.
Also, how can I have this trigger for certain users? For example, I would like to have this trigger for those with Profile "Sales" and not for "Manager" or "Salesforce Admin."
Thanks,
Boshra
2 件の回答
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Boshra,
You could try this:
AND(
ISPICKVAL(CurrencyIsoCode ,"USD"),
$Profile.Name="Sales",
OR(
AND( Product2.Name = "Band 1", UnitPrice < 7500),
AND( Product2.Name = "Band 2", UnitPrice < 8400)
