If Statement


Hi Team,

Can anyone help me how to write this condition In Smartsheet


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    That is just a sheet that I use for random testing. I have already deleted the data to make room for other things I wanted to test.

    It is set up the same way you have your screenshots where Price and Fruit are in different columns and then you have a third column for where the formula goes. Then I set up the table the same way you have in your first screenshot. All of it is on the same sheet since that is what you indicated as well.

    What is it that you need further clarification on?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!