IFS and CONTAINS

AppSheet AppSheet Q&A
1

Hi

I am trying to to put a price in a column, based on another column [Panel] containing certain codes. But not working. Advice where I am going wrong on this would be appreciated. Thanks in advance.

IFS([Panel] CONTAINS(“CMM40”),“25.50”, CONTAINS(“CMM101”), “21.50”, CONTAINS (“CMW102”), “28.50”)

2

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

2 Likes
3

thanks Bro, just seen where I have gone wrong… Thank you

1 Like