Drop Down List Matching Formula
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.
Answers
-
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,
Jamie
-
Great! Happy to help.
Help Article Resources
Categories
Check out the Formula Handbook template!