IF AND OR

Hello all,

I'm looking to use a Created By column to auto-fill my Primary column with a specific user's first and last name. I was planning on listing each user's email and full name with some variation of a IF/AND/OR or IFERROR statement, unless there's a more efficient alternative. Here is my current and one of many incorrect formulas I've tried:

=IF(AND(IF([Created By]1 = "USER1 EMAIL", "USER1 FULL NAME"), IF([Created By]1 = "USER2 EMAIL", "USER2 FULL NAME"))

I'd also like to have this formula being auto-filled as new columns are being created by a web-based form.

Thank you!

Find more posts tagged with

Forms

Construction

Formulas

Project Management

Comments

Paul Newcome

There is a much easier and more efficient way to do this. You would build out a grid with names in one column and corresponding emails along side it in another column.

You would then use something along the lines of

=INDEX([Name Column]:[Name Column], MATCH([Created By]@row, [Email Column]:[Email Column], 0))

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.