Skip to main content
Solved

Find certain text and exclude

  • May 22, 2023
  • 3 replies
  • 658 views

Forum|alt.badge.img+8

Hello!

Can someone please help me to upgrade the following formula?

I would like to add following statement: 

“If there’s [N/A] in the job name, (blank) result in the ‘Model FCST Month Dimension’ property.

IF(ISBLANK('[FCST] Greenhouse List'.'Start Date (Offer) Dimension'),

IF(ISBLANK('[FCST] Greenhouse List'.'Manual Input'),

'[FCST] Greenhouse List'.'Forecast Start Date Dimension','[FCST] Greenhouse List'.'Manual Input'),

'[FCST] Greenhouse List'.'Start Date (Offer) Dimension')

Thanks in advance!! 

 

 

Best answer by francois

Hi!

Have you tried using the CONTAINS function?

You could use something along the lines of IF(CONTAINS(“[N/A]”, List.’Job Name'), List.’Model FCST Month Dimension')

Hope this helps!

3 replies

francois
Employee
Forum|alt.badge.img+13
  • Employee
  • Answer
  • May 23, 2023

Hi!

Have you tried using the CONTAINS function?

You could use something along the lines of IF(CONTAINS(“[N/A]”, List.’Job Name'), List.’Model FCST Month Dimension')

Hope this helps!


Benji
Wallflower
Forum|alt.badge.img+7
  • Wallflower
  • May 25, 2023

Hey Yaeji! Did you manage to make this work? :)


Forum|alt.badge.img+8
  • Author
  • Master Author
  • May 25, 2023

Yes it worked thank you!!