Compare 2 Multi Select Drop Down Columns


I have 3 columns, all have the same multi select drop down options. I want the first column to be my selection, the second column is more of a checklist of what's complete, and the third column tells me what is left to be completed from the first column. Any idea if this can be done? Tried using collect formula.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!