Apr 26, 202308:44 AM - edited Apr 26, 202308:45 AM
See screenshot below. I'm using this to generate invoices. It does everything I want it to do, except for one thing. For the final invoice that the customer sees, I want all products, both custom and standard, to be listed in a single field (success!). Then I also want all product prices, both custom and standard, to be listed in a single field (no success! Circled in red).
Issues I've run into with using "&" and CONCATENATE:
1. I want everything separated by commas, but I don't want there to be a comma at the end, for example if there are only standard products and no custom products.
2. I want the column to be formatted as currency, the same way the "Itemized Prices" and "Custom product price" are already. When I have tried using various formulas, it tells me that my field is no longer a number or a currency and cannot be formatted. Please help!