I am not that good with programming or formulas so maybe whoever looks at this would be kind is this sounds impossible:
I have a field called currency. It is a picklist with the values: USD, EUR If the value is USD then I want the value in a field called "Total Revenue" to be copied to a field called "Amount in USD" If the value is EUR then I want the value in "Total Revenue" to be copied to a field called "Amount in EUR"
The Amount in USD and the Amount in EUR fields were created so that a report with two currencies can be shown-these two fields would be hidden on the page layout.
Is this possible to do? I have tried various formulas but none seem to fit the bill, so to speak,
I have a picklist field: Term: (less than 1 year, 1 year, 2 year, 3 year, 4 year)
I am trying to create a formula so that when Term = less than 1 year/only Total Revenue Amount field appears if Term = 1 year, only Revenue Amount Year 1and Total Revenue Amount
Term 2 = 2 year, only Revenue Amount Year 1 and Revenue Amount year 2 and Total Revenue Amount (would now add 1 and 2)
Term 3 = 3 year, only Revenue Amount Year 1 and Revenue Amount year 2 and Revenue Amount year 3 and Total Revenue Amount (would now add 1 and 2 and 3)
Term 4 = 4 year, only Revenue Amount Year 1 and Revenue Amount year 2,Revenue Amount year 3, Revenue Amount year 4and Total Revenue Amount (would now add 1 + 2 +3 + 4)
Any help would be greatly appreciated, Thanks, Jackie Simon
I am trying to change the label on the Log a Call button to Completed Tasks. I would like all the same functionality for organizations and accounts.
I have created the button but am having issues with what exactly to use for the formula within the button. I have looked at several post and tried several things but I keep getting a broken link page.
I am not that good with programming or formulas so maybe whoever looks at this would be kind is this sounds impossible:
I have a field called currency. It is a picklist with the values: USD, EUR If the value is USD then I want the value in a field called "Total Revenue" to be copied to a field called "Amount in USD" If the value is EUR then I want the value in "Total Revenue" to be copied to a field called "Amount in EUR"
The Amount in USD and the Amount in EUR fields were created so that a report with two currencies can be shown-these two fields would be hidden on the page layout.
Is this possible to do? I have tried various formulas but none seem to fit the bill, so to speak,
