I'm trying to create a formula to map to a matrix

Options

I know that I can't create a matrix in Smartsheet, but I'm working on creating a formula using two columns and need to have it return one of 4 answers.

If Column A is less than 3 and Column B is less than 3, then the answer should be "Bottom Left Corner"

If Column A is less than 3 and Column B is greater than 3, then the answer should be "Top Left Corner"

If Column A is greater than 3 and Column B is greater than 3, then the answer should be "Top Right Corner"

If Column A is greater than 3 and Column B is less than 3, then the answer should be "Bottom Right Corner"

I'm struggling with my If and And statements and nesting them. Any advice?


Thanks!

Best Answer

Answers

  • Allison H
    Allison H ✭✭✭
    Options

    Andrée,

    You are a miracle worker! The formula worked. Some of the fields weren't returning, but when I changed all of my ">" to ">=" then everything worked as expected. Thank you!

    Best,

    Allison

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Excellent!

    I'm always happy to help!

    Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!