I’ve seen this problem come up in a few posts, but have not seen the answer.
Its simple enough - and comes down to not quite understanding how to treat data that is a reference.
I cannot for the life of me make a formula for the button that is able to insert “Option 3” as a lookup into a new row in Table 2.
It should be easy to find option 3 using the “Add this row” column checkbox. Alas, it isn’t.
Everything I’ve come up with ends up inserting “Option 3” as text into the Option column in Table 2 instead of inserting it as a reference.
And this then breaks other bits of my workflow later on.
Can anyone suggest a formula that would work in this case - or am I going about things the wrong way?