IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemService"), RSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemService"), LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemInventory"), RSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemInventory"), LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemNonInventory"), RSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemNonInventory"), LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |