Formula when value in dropdown is selected - include these columns to generate the result

Ashley McCann

Based on the drop-down that is selected, how can I include these columns to generate the results based on their selection. For example

Column A: Asset Type

pdf

image

Column B: Industry

A

B

C

Column C: Topic

1

2

3

Column D: Subject Matter

free-write field

__________________________________________________

if selected pdf - include columns only C + D that will generate a URL string

ex: pdf-1-columndtext

if selected image - include columns B + C + D that will generate a URL strong

ex: image-a-1-columndtext

I appreciate your help!

Mark Cronk

=IF(isblank([column a]@row),"",IF([column a]@row = "pdf", [column a]@row+"-"+[column c]@row+"-"+[column d]@row, [column a]@row]+"-"+[column b]@row+"-"+[column c]@row+"-"+[column d]@row))

Mark