Formula Missing a row

jjg279

I have a pretty basic sheet that I am using to develop a formula, and am encountering an issue I haven't seen before. The formula isn't including my second row for some reason. It isn't a huge issue for my scratch sheet, but am curious as to what the underlying cause is so I can avoid it in future. Here is my formula:

And two examples of my results. the third one is what I would expect, but the first two are not.

DKazatsky2

Hi @jjg279,

I suspect the issue is due to not using "HAS" for the Food Given portion of the formula. Since that is a multi-select drop down, you should set up the criteria with "HAS" the same way you did for the Name column.

Hope this helps,

Dave

DKazatsky2

Hi @jjg279,

I suspect the issue is due to not using "HAS" for the Food Given portion of the formula. Since that is a multi-select drop down, you should set up the criteria with "HAS" the same way you did for the Name column.

Hope this helps,

Dave

jjg279

That was it! Thank you! Feel silly for missing, and really appreciate your help!