Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Function RELATED expects a fully qualified column reference as its argument

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
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Sorted.

     

    Just needed some extra paranthesis.

     

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Sorted.

     

    Just needed some extra paranthesis.

     

    Scenario = IF(AND(RELATED(Titleblocks[Scale Bar])=1,(RELATED(Titleblocks[Scale Text])=1)),"A","n.a.")
  • MFelix's avatar
    MFelix
    Super User
    6 years ago
    Hi Anonymous,

    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