Help with multiple IFContains Statements

Hi there,

I'm trying to do a formula but it doesn't seem to be working. I basically want to put a Yes or No in a sheet if 2 conditions are met - if one column of another sheet contains the age group 20-30 AND if another column of that sheet contains a code.

=IF(CONTAINS("20-30", {NELFT Talking Therapies - Message Request Range 3}), "Yes", "No") AND (IF(CONTAINS([ODS Code]@row,{NELFT Talking Therapies - Message Request Range 2}),"Yes","No"))

Could you please help?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!