Help

MultiSelect IF Formula

Topic Labels: Formulas
Solved
Jump to Solution
501 1
cancel
Showing results for 
Search instead for 
Did you mean: 
DaleNorris
4 - Data Explorer
4 - Data Explorer

Concept: 

 

I have 3 columns 

  1.  i  have a multi-select field of Job Types as follows
    1. Aerial Display - Water / Barge
    2. Aerial Display - Land
    3. Close Proximity
  2. I have a total invoice column in $ (approved spend)
  3. 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?

 

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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

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

 

See Solution in Thread

1 Reply 1
Sho
11 - Venus
11 - Venus

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

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