IF or CASE to show the correct data? | Community
Skip to main content
B
ByronNa1
Level 2
December 5, 2019
Question

IF or CASE to show the correct data?

  • December 5, 2019
  • 1 reply
  • 437 views
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.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

B
ByronNa1Author
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.
Terms & ConditionsAccessibility statement

Loading footer...