IF or CASE to show the correct data? | Adobe Higher Education
Skip to main content
Level 2
December 5, 2019
Frage

IF or CASE to show the correct data?

  • December 5, 2019
  • 1 Antwort
  • 437 Ansichten
I would like to pull data into one column based on what is chosen in the previous column. Column "A" contains a list. Each item in that list represents another list. I'd like the field for the child list to be displayed in column "B". I'm trying IF statements but the text editor is getting really slow when I add more than two statements. Would CASE even work for this? Or is there another approach to use? Byron Nash INSP, LLC.
Dieses Thema wurde für Antworten geschlossen.

1 Antwort

Level 2
December 5, 2019
Here's my code. IF({project}.{DE:Program Type}="Acquired Movies",{project}.{DE:Acquired Movies}, IF({project}.{DE:Program Type}="Acquired Series",{project}.{DE:Acquired Series}, IF({project}.{DE:Program Type}="Events",{project}.{DE:Events}, IF({project}.{DE:Program Type}="Blocks",{project}.{DE:Blocks},"Twizzlers")))) (edited to correct formatting issue) Byron Nash INSP, LLC.