Function RELATED expects a fully qualified column reference as its argument

[jagostinhoCT]

Hello,

Getting the error 

"Function RELATED expects a fully qualified column reference as its argument."

when trying to create a new column in the [Sheets] Table using this formula.

Scenario = IF(AND(RELATED(Titleblocks[Scale Bar]=1),(RELATED(Titleblocks[Scale Text]=1))),"A","n.a.")

I found this post for the same error but it looks that we are trying different things.

Thank you for your help.

J

[MFelix]

Hi @jagostinhoCT,

Believe your issue is related with the end of the formula parênteses. Try the following


Scenario = IF(AND(RELATED(Titleblocks[Scale Bar]) =1, (RELATED(Titleblocks[Scale Text]) =1)),"A","n.a.")

Regards,
MFelix

[jagostinhoCT · Accepted solution]

Sorted.

Just needed some extra paranthesis.

Scenario = IF(AND(RELATED(Titleblocks[Scale Bar])=1,(RELATED(Titleblocks[Scale Text])=1)),"A","n.a.")