Help with an Index Match

swaldon2

swaldon2 ✭✭✭✭✭

10/31/24 edited 10/31/24 in Formulas and Functions

I have two sheets and I want to use a formula to tag the legal responsible person based on the entity. I can't figure out what index formula to use, please help!

The formula should be in the legal reviewer column and populated from the first screenshot

Tags:

Formulas

0 ·

Best Answer

swaldon2 ✭✭✭✭✭

10/31/24 Answer ✓

I have resolved this

0 · Share on Facebook Share on Twitter

Answers

swaldon2 ✭✭✭✭✭

10/31/24 Answer ✓

I have resolved this

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to update certain cells in column based on one cell's input and other column's same ID #?
I have a very simple test script testing tracker located here: I want to be able to do one of the following: 1. Update the Status column for all testers with the same test ID to "Duplicate" once one person tests and puts "FAIL" in the PASS/FAIL column. 2. Do not copy defects to defect tracker sheet if one of the rows with…
Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…