I need some help with a broken reference. I keep getting the yellow triangle on this, but best I can tell, the reference is correct. I even renamed a few things to make 100% sure I was targeting the right value.
The correct options show in the dropdown, and appsheeet even automatically filled in the value for data validation, so I am not sure what I am doing wrong here.
Your Valid If expression is wrong: it should reference the hospital_ID column rather than the hospital_name column.
would you mind explaining this further? The hospital_ID column only contains a UNIQUEID() value and not the actual text iād like to have displayed in the dropdown. What have i missed?
You can only reference key columns. However, you can still display the values of another column by marking that column as Label.
thank you, this makes sense to me now 
