Skip to main content

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?

 

 

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

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

 

Reply


Terms & Conditions