Help

More help with IF, FIND in formulas

Topic Labels: Formulas
759 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Hazel_Johnson
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve tried to follow along with the other questions on this topic, but I keep getting “Invalid formula”.

I have three fields (that all link to another table). “Ayes”, “Nayes”, and “Absent.” If “Adams” appears in the “Ayes” column, the target field should be “voted for”. If “Adams” appears in the “Nayes” column, the target field should be “voted against.” And if “Adams” appears in the “Absent” column, the target field should be “did not vote on”.

Here’s what I have:

IF(Find(“Adams”, {Ayes}, “voted for”), Find(“Adams”, {Nayes}, “voted against”), Find(“Adams”, {Absent}, “did not vote on”)

Thoughts?

2 Replies 2
Hazel_Johnson
5 - Automation Enthusiast
5 - Automation Enthusiast

So this individually works for “voted for”:

IF(FIND(‘Adams’, {Ayes}), “voted for”)

But I’m still having problems with the longer version:

IF(FIND(‘Adams’,{Ayes}), “voted for”, FIND(‘Adams’,{Nayes}), “voted against”, FIND(‘Adams’,{Absent}), “did not vote on”)

When go back into the formula, it shows a truncated version:

IF(FIND(‘Adams’,{Ayes}), “voted for”, FIND(‘Adams’,{Nayes}))

Hazel_Johnson
5 - Automation Enthusiast
5 - Automation Enthusiast

GOT IT!

IF(FIND(‘Adams’,{Ayes}), “voted for”) & IF(FIND(‘Adams’,{Nayes}), “voted against”) & IF(FIND(‘Adams’,{Absent}), “did not vote on”)

Does exactly what I need.