Færdiggjort

Excel or Smartsheet or Google sheets Expert needed

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,

Step 1

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.

Step 2

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.

Basil=Large-[PRICE],Standard-[PRICE],Small-[PRICE]+goats cheese=Large-[PRICE],Standard-[PRICE],Small-[PRICE]

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.

Evner: Excel, Microsoft Office, Google Sheets

Se mere: google excel sheet edit, google sheets vs excel 2020, excel sheet or google sheet, excel vs google sheets reddit, google sheets vs excel, benefits of smartsheet vs excel, disadvantages of google sheets, how to use google sheets, google adsense expert needed, google adwords expert needed, seo expert needed top ranking keywords google, excel expert needed virtual assitant, query excel sheet excel expert needed, google maps project google maps expert needed, excel convert google sheets, convert excel to google sheets, automatically convert excel to google sheets, convert excel to google sheets in drive, how to upload excel to google sheets, vlookup from excel to google sheets

Om arbejdsgiveren:
( 13 bedømmelser ) Berwick, Australia

Projekt ID: #27425629

Tildelt til:

Shodi39

Hi, I understand that you need a versatile formula that helps you extract the required exact result based on data provided. I can do this using a combination of array, lookup and srting formulae. I have over 8 years of Flere

$12 AUD / time
(0 bedømmelser)
0.0

59 freelancere byder i gennemsnit $11/time for dette job

schoudhary1553

Hi, Greetings! ✅checked your project details: Excel or Smartsheet or Google sheets Expert needed ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same Flere

$20 AUD / time
(366 bedømmelser)
8.1
(229 bedømmelser)
8.0
(386 bedømmelser)
7.3
(110 bedømmelser)
6.3
(41 bedømmelser)
6.5
(141 bedømmelser)
6.6
(164 bedømmelser)
6.5
IgeS

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

$10 AUD / time
(25 bedømmelser)
4.9
Servicehour24

Dear Employer, You've specified that you need an Excel Expert. I am an Excel & Google Sheet Expert with 7+ years of experience. I would like to help you with confidence and satisfying results. I have worked on several Flere

$12 AUD / time
(6 bedømmelser)
4.6
BHARATBEURA

HELLO, MYSELF BHARAT. I’M A PROFESSIONAL DATA ENTRY EXPERT. I COLLECT DATA FROM PDF/WEBSITE AND FILL IN THE SPREADSHEET WITH DATA IN THEIR RESPECTIVE FIELDS. I WILL PROVIDE YOU WITH HIGH-QUALITY SERVICES IN REASONABLE Flere

$8 AUD / time
(27 bedømmelser)
4.9
KuldeepGera

Hello, I have worked with all three of them and got a rough idea of what you are trying to achieve, please provide the access of the sample sheet for me to be sure and we can proceed further. I can begin working on i Flere

$15 AUD / time
(19 bedømmelser)
4.2
emilianoreyes70

Hello! I am an engIneer, Excel/VBA/Macro expert,Google Scrpit and Google Sheets expert . I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including the preparation o Flere

$10 AUD / time
(15 bedømmelser)
4.3
SIBTEHASSANBUTT

Hi there, I have read your project entitled “ Excel or Smartsheet or Google sheets Expert needed ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using excel and other data visual Flere

$20 AUD / time
(9 bedømmelser)
3.6
Sunitav36

HI, I have checked the project : Excel or Smartsheet or Google sheets Expert needed I am proficient in excel and i have 9+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data ex Flere

$11 AUD / time
(11 bedømmelser)
3.3
MonicaMF

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

$11 AUD / time
(3 bedømmelser)
2.0
nishajaryal37

Hello there, I am Nisha(Data Entry Expert) with experience of more than 5 years. I worked for multiple clients internationally and made them happy by providing them more than their expectations. Following is my most Flere

$9 AUD / time
(3 bedømmelser)
2.2
NABaloch

Dear Sir. I have read the job description and got very interested in working on this project as it perfectly fits in my skill stack. I am a researcher. I have 10+ years of experience of MS Excel . I used to work in Flere

$9 AUD / time
(0 bedømmelser)
0.0
JustineJanine

I am Justine Janine  Ulanday and I find your job hiring applicable to my skills. I have 8 years of working experience. 2 of these years is for Administrative staff and Document Controller. More than 4 Years if for Sale Flere

$8 AUD / time
(0 bedømmelser)
0.0
alymony788

i have Certificates Microsoft Office "MOS" in Office PowerPoint 2010,Office Access 2010,Excel Expert 2010

$15 AUD / time
(0 bedømmelser)
0.0
sscbe

Hi, I this project can be done. I have thought of a concept for this project and if my understanding of your requirement is correct then this project can be done, but for that I require your sample sheet & may be a cha Flere

$8 AUD / time
(1 bedømmelse)
0.0