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

Options

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!

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    =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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!