List with Text - Reda one value of a virtual column

AppSheet AppSheet Q&A
, , , , ,
1

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

2

IFS( CONTAINS( [staff notes] , ‘return’ ) , ‘return’ )

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

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

1 Like
3

@Marc_Dillon Perfect, thanks very much