Dropdown Multi select - ~If formula

Jose da Silva
Jose da Silva ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi all,

 

Been searching about this, but could not find anything so far. Hopefully you can help me.

I am just starting to make use of the multi select dropdown list.

So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a single column for each of the options from the dropdown. What i need to do is use a formula on each of those that basically applies the following logic -> "if this valie is ticked on the multi drop, then also tick it here"

 

How would that work?

 

Thanks in advance.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!