Error in Formula

Hi I have a enum field “Style of curtain” and it has drop down option such as Plain curtain,Eyelet curtain. So what I am trying to achieve is to calculate cost of stitching & based on the style of curtain selected the formula has to get applied and I have written the formula as such but getting an error as below :
Cannot compare Text with List in ([Style of curtain to be stiched] = LIST(“Plain”,“Plain with lining”,“Rod pocket”,“Rod Pocket with Lining”,“Backloop”,“Back loop lining”))

Formula is :
IFS([Style of curtain to be stiched] = {“Plain”,“Plain with lining”, Rod pocket,Rod Pocket with Lining,Backloop,Back loop lining},([Lengths required] * [Rate per length (Curtain)]),([Length required] * [Rate per length (Curtain)]))

If any one could help me out where I am going wrong?

Please try

IF(IN([Style of curtain to be stiched], {“Plain”,“Plain with lining”, “Rod pocket,Rod Pocket with Lining” , “Backloop,Back loop lining” }) ,([Lengths required] * [Rate per length (Curtain)]),([Length required] * [Rate per length (Curtain)]))

2 Likes

For reference:

2 Likes

Thank you sir the solution did work for me.

1 Like

Thank you

1 Like