Giving an output based on text from multiple selection dropdown
I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date "Finish Start." Both columns are on the same sheet, even though the "Processes" column pulls from another sheet.
Currently, I've been seeing multiple uses of an If/Then formula with "Contains" in it. It seems like the right solution, it's just not giving me a result. This is my current formula =IF(CONTAINS("FAB - Finish", Processes@row, 3, 0))
Help Article Resources
Check out the Formula Handbook template!