How to see values that are not in drop down list?

Is there way to see the cells where values do not match the values added to column that is formatted to a restricted drop down list? This would be super helpful to troubleshoot and remove errors from sheets.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!