DATE function for drop down menus

edited 12/09/19 in Formulas and Functions

Hi all,

I am using a drop down including different years (2019, 2020, 2021, etc.) that I need for the card view. Based on the selected drop down value in Column 1 (e.g. 2020) I want to auto-populate a ‘date’ field with the first day of the year (e.g. 2020.01.01) in column 2. I tried to use the following:

= DATE ([Column 1]@row, 1,1) 

which is not working (#INCORRECT DATA). This is, I think, due to the fact that using a drop down menu is causing the cell value to be ‘2020 and not 2020. Any way to get rid of the ‘ in the cell? Any formula that can be used here?


thanks, Elias


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!