Adam Wideman

I'm not sure if I'm doing this totally correct or if I need to make a whole different set of custom metrics to pull this off, but I'm trying to add some custom fields to my Organizations for "Service Agreements".  Each agreement, of which there are 3 for each organization possible, would have a "Contract Number", "Hours Purchased", and a "Contract Value".  I need to pull in Hours Purchased and Contract Number in order to run a query against how many "hours billed" against the "Hours Purchased".  I've been able to do this easily with just one contract, but now its causing some erroneous data when we have multiple contracts involved.  SO  I want a field thats SUPER smart.  I need one that knows to show hours purchased relevant to which Contract Number is used.  The matching field is called "Ticket Sage Reference" (also custom) and lives in the ticket.  I want to say something like

IF ([Ticket Sage Reference]=VALUE(ContractNumber))
THEN 1
ELSE IF ([Ticket Sage Reference]=VALUE(ContractNumber2))
THEN 2
ELSE IF ([Ticket Sage Reference]=VALUE(ContractNumber3))
THEN 3
ENDIF

Then one that would ACTUALLY display the content

IF ([CustomMetric]=1)
THEN VALUE(ContractNumber1)
ELSE IF ([CustomMetric]=2)
THEN VALUE(ContractNumber2)
ELSE IF ([CustomMetric]=3)
THEN VALUE(ContractNumber3)
ENDIF

I'm terrible with functions, please send help . I think I may even be at the point where I may even pay Zendesk to write this for me, but wanted to see if anyone could steer me in the right direction before i did that.