Nov 07, 2019 07:19 AM
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?
Nov 07, 2019 08:06 AM
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}))
Nov 07, 2019 08:28 AM
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.