IFERROR and INDEX/MATCH formula with criteria?


I am using this formula currently on a work document (slightly modified):

=IFERROR(INDEX({Assigned Specialist}, MATCH([Project Name]@row, {Project Title}, 0)), "")

Now, what I would like to add is a criteria to this formula that checks the other sheet (the same sheet that Assigned Specialist is on) to see if the Project Status is Complete or Disabled, and if it is, then to just return "". Essentially, I only want the formula to return the Assigned Specialist name if the project is still active.

Is that possible?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!