List with Text - Reda one value of a virtual column

[aminsaleh]

Hi all, 

I have a table called Orders

Inside that table there are:

► a real column called (staff notes) of Enumlist type

► a virtual column called (Return) of Text type.

Please note both are in the same table. Now what I am trying to do is to make a formula in the virtual column that reads the data in the (staff notes) column and if there is a word "Return" it shows the same word "return" in the virtual column.

------------

I have tried this but got an error (Cannot compare List with Text)

SELECT(Orders[Staff Notes], ([Staff Notes] = "Return"), TRUE)

Thanks indeed

[Marc_Dillon · Accepted solution]

IFS( CONTAINS( [staff notes] , 'return' ) , 'return' )

https://help.appsheet.com/en/articles/2355961-ifs

https://help.appsheet.com/en/articles/2347639-contains

[aminsaleh]

@Marc_Dillon  Perfect, thanks very much