Dropdown Multi select - ~If formula
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.
Help Article Resources
Check out the Formula Handbook template!