I'm trying to create a formula to map to a matrix
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

Hi Allison,
Try something like this.
I added the ISBLANK check so it works if one of the cells is blank.
=IF(OR(ISBLANK(A@row); ISBLANK(B@row)); ""; IF(AND(A@row < 3; B@row < 3); "Bottom Left Corner"; IF(AND(A@row < 3; B@row > 3); "Top Left Corner"; IF(AND(A@row > 3; B@row > 3); "Top Right Corner"; IF(AND(A@row > 3; B@row < 3); "Bottom Right Corner")))))
The same version but with the below changes for your and others convenience.
=IF(OR(ISBLANK(A@row), ISBLANK(B@row)), "", IF(AND(A@row < 3, B@row < 3), "Bottom Left Corner", IF(AND(A@row < 3, B@row > 3), "Top Left Corner", IF(AND(A@row > 3, B@row > 3), "Top Right Corner", IF(AND(A@row > 3, B@row < 3), "Bottom Right Corner")))))
Depending on your country you’ll need to exchange the comma to a period and the semicolon to a comma."
Did it work?
I hope that helps!
Have a fantastic day & Happy New Year!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅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.
Answers

Hi Allison,
Try something like this.
I added the ISBLANK check so it works if one of the cells is blank.
=IF(OR(ISBLANK(A@row); ISBLANK(B@row)); ""; IF(AND(A@row < 3; B@row < 3); "Bottom Left Corner"; IF(AND(A@row < 3; B@row > 3); "Top Left Corner"; IF(AND(A@row > 3; B@row > 3); "Top Right Corner"; IF(AND(A@row > 3; B@row < 3); "Bottom Right Corner")))))
The same version but with the below changes for your and others convenience.
=IF(OR(ISBLANK(A@row), ISBLANK(B@row)), "", IF(AND(A@row < 3, B@row < 3), "Bottom Left Corner", IF(AND(A@row < 3, B@row > 3), "Top Left Corner", IF(AND(A@row > 3, B@row > 3), "Top Right Corner", IF(AND(A@row > 3, B@row < 3), "Bottom Right Corner")))))
Depending on your country you’ll need to exchange the comma to a period and the semicolon to a comma."
Did it work?
I hope that helps!
Have a fantastic day & Happy New Year!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅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.

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

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!