Struggling with INDEX and MATCH

Hello,

I am trying to automate task assignment using the INDEX and MATCH functions. My formula is as:

=INDEX({Order Sets Team Contact Roster Assigned To}, MATCH(Role@row, {Order Sets Team Contact Roster Role}, 0))

It seems to work for one role but produces a no match error for the rest of the roles. Please see attached screenshot. Any advice on how to correct this would be amazing!

Thanks-

Katye

Find more posts tagged with

Healthcare

Formulas

Project Management

Comments

Paul Newcome

Do you have multiple contacts per cell? If not, is that feature enabled? Does that feature match in both the source contact column and the target contact column? Are the Roles' texts an exact match (lead vs leads, etc)?

Sign in to join the conversation!

Quick Links

Trending discussions

Help with automation to find bad formatting
I have a sheet accessed by monkeys users who keep managing to muck up a currency column. They are either pasting in amounts from some other source or literally typing in the dollar sign followed by a number, or something. The result is reports that lose their currency formatting. Smartsheet seems to treat these bad entries…
Please help to convert this Excel formula to a usable Smartsheet formula
Hi my colleague has imported an Excel spreadsheet and one of the formulas hasn't worked on import. Please could someone let me know if the following Excel formula can be converted into a usable Smartsheet formula? Here it is: =IF(B4<>"", ROW()-1, "") Many thanks, Lee
Getting Unparseable error using IF function
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…