The currency fields are:
- Fee 1
- Fee 2
One or both can be populated depending on the Opportunity details. The formula field should look at both of these fields and determine if one or both of the fields are populated. If only one is populated (either one), the formula should return a "1." If both are populated, the formula should return a "2."
I can't seem to get a working formula for this. Any help would be awesome!
답변 6개
So here is how you build that = When Fee 1 is populated =
IF( NOT(ISBLANK(Fee1)), 1, 0 )
When Fee 2 is populated =
IF( NOT(ISBLANK(Fee2)), 1, 0 )
Now just add them up =
IF( NOT(ISBLANK(Fee1)), 1, 0 ) +
IF( NOT(ISBLANK(Fee2)), 1, 0 )
That is it!
