Help with IF(AND) formulas

Kitty
Kitty ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

= IF[Instructor 1 Last Name]@row = "" - AND [Instructor Status]@row = "U.S. Instructor" - I need it to count as 1.  Otherwise, 0.

What I've written above is what I want to do.  Below is the formula, which gives me the dreaded #UNPARSEABLE.

=IF(AND([INSTRUCTOR 1 LAST NAME]@row=””, [INSTRUCTOR 1 STATUS]@row=”U.S. Instructor”, 1, 0))

After I can get this straightened out, then it becomes more complicated.

Then I need to check that Instructor 2's LAST NAME does not equal Instructor 1's LAST Name.

Then I need to check that Instructor 3's LAST NAME does not equal Instructor 1 & 2's LAST NAMES

Finally, I'll need to check that Instructor 4's LAST NAME does not equal Instructor 1, 2, & 3's LAST NAMES.

Sometimes we have a group of instructors who go to teach in one location. Sometimes we only have 1 instructor who will teach at least 2 courses. (Even though there are 2 courses taught, we only count it as 1 instructor even though his name will appear twice for this trip.)

I need a count of instructors who go to teach each quarter, and I need to know if they are Nationals or if they are U.S. Instructors.

All names columns are TEXT only. (My brain is slowly frying....)  :) Thanks for any help!!

 

Tags:

Comments