Calculation
Ben Sowden asked 7 years ago
Hi All,
I am trying to come up with a way that I can use a calculated field to return 2 sets of data based on the initial lookup..
I have 2 fields (PO Number) and I want a calculated field to look at this and if there is nothing in there (black) insert another number (Invoice Number)
I currently have both of these fields as _PURCHASEORDERREFERENCE and _ORDERNUMBER getting pulled into smart connect.
I am trying to come up with a way that I can use a calculated field to return 2 sets of data based on the initial lookup..
I have 2 fields (PO Number) and I want a calculated field to look at this and if there is nothing in there (black) insert another number (Invoice Number)
I currently have both of these fields as _PURCHASEORDERREFERENCE and _ORDERNUMBER getting pulled into smart connect.