Drop Down List Matching Formula


I have two columns and each column has a multi drop down box. I have been trying to create a formula that will return a date in a 3rd column when the first two columns drop down list match. Any assistance is appreciated.


  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Hi @jkizner ,

    Do you want to put a specific date in the field if they match? If so, you could use something like:

    =IF(column1@row = column2@row, DATE(2022,1,31),"")

    This translates to if Column1 matches Column2, insert January 31, 2022 in the date column.

    If the date is not a specific date, but relative to something else, we'd need to dig a little deeper - with the potential of using automations or formulas.

    Also - it's important to distinguish between single-select dropdowns and multi-select dropdowns, as formulas treat them differently.

  • Hi,

    This worked!

    Thank you,


  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Great! Happy to help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!