Yellow Triangle in ref type column

[alhazen]

Hello,

How to fix yellow triangle appearing when selecting column ref type?

i am using this formula Select(process[functional_group],[department]=[_THISROW].[department])

This is the source data

I want the user to be able to add another functional group if it is not available in the datasource?

Is it possible?

Thank you very much

[TeeSee1]

Ref cols only store the key values of tables.

If [functional_group] is NOT the key of process, change the type to TEXT

[alhazen]

Hello @TeeSee1 Thank you for your response.

It does work, but I can't add another functional group data to the process table if it's not in the list. Is there any other way so that I can add other data if it's not in the list and it's also stored in the google sheet?

[TeeSee1]

You need to create a separate Functional Group table and create columns where  appropriate referencing it because it is "Master data" just like customers, states, products, categories, etc etc.

https://innoscale.de/en/difference-master-data-and-transaction-data/