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)
