Expand my Community achievements bar.

IF or CASE to show the correct data?

Avatar

Level 3
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.
1 Reply

Avatar

Level 3
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.