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
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.