I am a novice when it comes to formulas, so please excuse my ignorance.
I have two columns that I need to reflect in the formula. One is a checkbox and the other is a store location column.
What I am trying to get the formula to show is if the discontinued checkbox is selected and the store location of Assembly Street is entered, then it will show “dqabc”
Additionally, if the discontinued checkbox is selected and the store location is Piney Grove, then it will show “dqpiney”
Now I can make the formula do that, my problem is that you can select multiple locations and I need the formula to reflect more than one result if both store locations are there. For example, if Assembly Street and Piney Grove are selected and the discountinued box is checked it would show “dqabc, dqpiney”
It’s the showing two results I cannot seem to figure out. I thought you had to used an IF(AND condition but I cannot get it to work.
Here is the formula I was using. I just don’t know how to link them together to get two results if both store locations are selected.
IF(AND({Discountinued}, {Store Location(s)#Labels}=“Assembly Street”), “dqabc”,
IF(AND({Discountinued}, {Store Location(s)#Labels}=“Piney Grove”), “dqpiney”, “”))