Est. Budget: $50.00
We have the following spreadsheet:
We need column B to contain a dropdown list of items, but have the list of items vary whether there's a valid email in the corresponding row, column C.
So for example - if C1 contains a valid email address than B1 will have a dropdown list with these values: s1,s2
If C1 does not contain a valid email address than ...