Concept: I have 3 columns i have a multi-select field of Job Types as followsAerial Display - Water / BargeAerial Display - LandClose ProximityI have a total invoice column in $ (approved spend)I have a formula column with the current formula "IF({Job Type}="Aerial Display - Water / Barge", ({ApprovedSpend}-2000)*.27, {ApprovedSpend}*.27)I have run into the issue that when the column 1 (job type) has more then just "aerial Display water/barge" selected it ignores the first, part of the formula. so I'd rather it be something along the lines of IFCONTAIN?

Solved

MultiSelect IF Formula

Forum|Forum|2 years ago
October 2, 2023
1 reply
13 views

D

DaleNorris
New Participant

Concept:

I have 3 columns

i have a multi-select field of Job Types as follows
1. Aerial Display - Water / Barge
2. Aerial Display - Land
3. Close Proximity
I have a total invoice column in $ (approved spend)
I have a formula column with the current formula "
IF({Job Type}="Aerial Display - Water / Barge", ({ApprovedSpend}-2000)*.27, {ApprovedSpend}*.27)

I have run into the issue that when the column 1 (job type) has more then just "aerial Display water/barge" selected it ignores the first, part of the formula. so I'd rather it be something along the lines of IFCONTAIN?

Best answer by Sho

Do you mean you want all "Aerial Display -" to be true?

IF(FIND("Aerial Display - ", {Job Type}),({ApprovedSpend}-2000)*.27, {ApprovedSpend}*.27)