Skip to main content

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?

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}))

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.

Terms & ConditionsAccessibility statement