Help with multi-conditional contains formula

Hi there! I am struggling with finding a formula to assist with the following two scenarios. Please see screenshot for layout of columns for reference

Scenario 1:

  1. If the Child Account column contains TN Oncology
  2. and the Task Name column contains CDA Signed
  3. I want the value that is populated in the Status column to pull into a new sheet

Scenario 2:

  1. If the Child Account column contains TN Oncology
  2. and the Task Name column contains US
  3. I want US to pull into a new sheet

Any assistance would be greatly appreciated, I am losing my mind over something I'm sure is a simple fix :)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!