Dropdown condition "is not empty"

  1. Does the AI Formula Bot only help with selected column?
  2. Reference Column: How do I omit blank/empty cells from being reference?
    Dropdown Filter: None of these work
  1. My experience is that the AI Formula Bot is not overly helpful with dropdown conditions.
  2. In a quick test, a Reference column pointing to a column with empty cells does not provide a blank option in the dropdown list. However, if you are seeing this behavior, if you review the help docs for Reference columns: https://support.getgrist.com/col-refs/#filtering-reference-choices-in-dropdown-lists you’ll find that you have to refer to the choice attribute for your reference column. It would look something like:
choice.UPC != None