5 Replies Latest reply on Nov 21, 2018 3:05 PM by Penn Wang

    How to create a dropdownlist without null value

    Penn Wang

      Hi Everyone,


      This could be an easy question, just couldn't get my head around.


      I have a datetime column which data keeps rolling in. I have created a dropdownlist (see below) however there is an option for choosing null value. I can't simply select all the values other than null because there will be new month/year.



      I am thinking about creating a calculation field to filter out null value first, then build a dropdownlist on the new column.


      Thank you.