Drop Down List Matching Formula

jkizner

Hi,

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

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.

jkizner

Hi,

This worked!

Thank you,

Jamie

Heather Duff

Great! Happy to help.