Formula help with multiple choices
I thought I saved the one I added so if this is duplicate I apologize, I could not find my original. I want to have a formula field that says this but the , between Pacific Dunes 2 and [#of people i...
Forum Discussion
I tried this but the coma after Pacific Dunes 2 comes up yellow
IF(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2",
[Salesroom]="GS Landsend",([# of people in party]+1)*9.63
[Salesroom]="Playa Grande",([# of people in party]+1)*7.81
I also did it and still yellow at comma
IF(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2",
If(contains([Salesroom]="GS Landsend",([# of people in party]+1)*9.63)
IF(Contains[Salesroom]="Playa Grande",([# of people in party]+1)*7.81)
Hi,
Can you confirm regarding the formula correction provided 4 days ago ? Your SalesRoom should ideally be containing only 1 value.
If(
[Salesroom] = "Pacific Dunes 1", "Pacific Dunes 2",
[Salesroom] = "GS Landsend", ([# of people in party] + 1) * 9.63,
[Salesroom] = "Playa Grande", ([# of people in party] + 1) * 7.81
)If you must use contains which is a weird case for SalesRoom, then below should be fine.
If(
Contains([Salesroom], "Pacific Dunes 1"), "Pacific Dunes 2",
Contains([Salesroom], "GS Landsend"), ([# of people in party] + 1) * 9.63,
Contains([Salesroom], "Playa Grande"), ([# of people in party] + 1) * 7.81
)I still receive a yellow mark after 9.63 it says it's expecting a ) but when I put that there it turns [Salesroom] yellow - if I start salesroom with a ( and end with ) its still yellow
If([Salesroom]="Pacific Dunes 1","Pacific Dunes 2", [Salesroom]="GS Landsend",([# of people in party]+1*9.63,[Salesroom]="Playa Grande",([# of people in party]+1)*7.81
oh and also I tried it this way - which almost worked - at the very end it's expecting a ) but when I put it at the end then # of people turn yellow
If([Salesroom]="Pacific Dunes 1","Pacific Dunes 2", [Salesroom]="GS Landsend",([# of people in party]+1*9.63), [Salesroom]="Playa Grande",([# of people in party]+1)*7.81
When it turns yellow, you can hover over it and see what is the error.
Maybe field [# of people in party] is text field and you need to convert it tonumber([# of people in party]).
You can also check App Settings for Numbers decimal mark.
