Post by mattias on May 7, 2019 18:16:55 GMT
Data validation lists become searchable in Molnify, but you need to create them in the right way in Excel. A data validation list will only work in Molnify if you create it by following these steps:
1, In Excel, select the cells that you want to have in your list (like A1:A150)
2, Name the range in Excel (like in the image below)
3, Place yourself in the cell where you want to have the list. Go to data, then data validation. Click List and then, if you named your range "mylist" type =mylist and then click enter.
3, Give your input a name and then color the cell containing the data validation list green. If you have very few entries in your list, you will get radio buttons instead of a list. To push this to become a list, specify "dropdown" in the UI-cell (the cell to the right of the green input cell).
4, Save and upload your file to Molnify. Then unsearchable data validation list has become a searchable dropdown list
Best regards Mattias
1, In Excel, select the cells that you want to have in your list (like A1:A150)
2, Name the range in Excel (like in the image below)
3, Place yourself in the cell where you want to have the list. Go to data, then data validation. Click List and then, if you named your range "mylist" type =mylist and then click enter.
3, Give your input a name and then color the cell containing the data validation list green. If you have very few entries in your list, you will get radio buttons instead of a list. To push this to become a list, specify "dropdown" in the UI-cell (the cell to the right of the green input cell).
4, Save and upload your file to Molnify. Then unsearchable data validation list has become a searchable dropdown list
Best regards Mattias