Search data when having multiple conditions


I want to bring the data from a reference field to another sheet having two conditions in a row

Best Answer

  • Hayber
    Hayber ✭✭
    Answer ✓

    Hello @Purnima Gore_PGPS and @Andrée Starå

    I have solved it with the following formula, which searches for the two data in book 1 (one fixed data and another is the date) and brings the information of a 3 data to the book. Making the condition of two data to bring it, IFERROR also allows leaving the cell blank if it does not yet have information.

    =IFERROR(INDEX(COLLECT(Referece book1Result; Reference book1 variable1; "consultation"; Reference book1 variable2; Date current book); 1); "")

    Greetings and thanks for responding


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!