Hi all,
I have a side by side question (see below) where I want to force response column A but leave column B optional.
I cannot seem to find a solution in custom validation except listing all the possibilities where count(option 1) + count(option 2) + count(option 3) = 6 (that's 28 combinations * 3 lines per combination). I wonder whether there is an easier way to do this, possibly with custom code.
Thanks!
Best answer by CarolK
View original