Looking for someone who is an expert on Excel or Smartsheet or Google sheets to help us achieve a formula to split text into multiple column and build then build up one cell that contains joined text in a specific format. Example,
A user selects Sizes (column 1) and Ingredients (column 2) from a multi select drop down in Smartsheets. I would be happy to do the same with Google or Excel sheets but it doesn't allow multi select in a dropdown, hence we used smart sheets for this task.
Goal is that we need to arrive at this exact text where Basil, goats cheese etc are the ingredient, Large, Standard, Small are sizes and PRICE is a constant text across.
There will be multiple sizes and large number of ingredients selected in Step1 so we need to formula to be flexible to cater to it.
Pls apply for the project if you know how to achieve it. I will provide access to sample sheet.
59 freelancere byder i gennemsnit $11/time for dette job
Hi there, Is your requirement a customized price list or quotation? Please message if your ok to do it using app script in Google Sheet or VBA in Excel. I’ll be standing by to help. Ige
Hello, I can help you with the excel project, to split one text into multiple columns and create dropdown by multiples categories as needed. Best regards, Monica