How to pull information from a cell of different sheet when the given conditions are met?


I tried using If & Contains but i realized it is doing for the columns but I required my formula to look at rows not the columns. And if given conditions are met, I want to pull the information from that row. Please help?

Best Answer

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭
    Answer ✓

    Hi @ABHI

    The formula in your [Work Order No.] column on the first sheet should be this one:

    =INDEX(COLLECT({Work Order No Range}, {Equipment Range}, [Machine/Equipment]@row, {PM SCHEDULED Range}, "YES"),1)

    That is if I understood your screenshot correctly.

    Hope it helped!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!