Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Cross reference logic help needed

I need to be able to check if a set of conditions is met across different rows in another sheet. I need to determine if supporting projects should be yes if supporting helper column is yes in the other sheet. If any of the rows for a project resource has a yes in supporting helper column that resource should have a yes in supporting project in the other sheet.

Best Answer

  • ✭✭✭✭✭✭
    Answer ✓

    Hello @Jess A ,

    I replaced the VLOOKUP with IF logic embedded with HAS and Cross Sheet Reference.

    It worked for me.

    =IF(AND(HAS({Project Hours Question Project Resource}, Resource@row), HAS({Project Hours Question Project Resource Supporting Helper Column}, "Yes")), "Yes", "No")

    Scenario 1 ⇒ Jane Doe last Record is Yes

    Erin Horiuchi Green, MBA, LSSYB, PSMI
    Process Manager
    Syneos Health

    Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.

    Core App and Project Managment Certified 🚀

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions