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.

Formula Missing a row

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.

Best Answer

  • Community Champion
    Answer ✓

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions