If Statement

04/23/21
Accepted

Hi Team,

Can anyone help me how to write this condition In Smartsheet


Thanks

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted 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?

    thinkspi.com

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Are you able to provide more details? Are you trying to populate the A, B, and C columns, or are you trying to reference the table to pull values based on "Apple" and "A" being entered?

    thinkspi.com

  • Hi @Paul Newcome

    THanks for your quick response

    So, Its should be

    if Fruits= "Apple", Price ="A", "H" , if Fruits= "Apple" , Price="B","H", Fruit ="Apple" ,Price ="C","L"


    Like this..

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Is this table on the same sheet as the data you are evaluating, and are "Fruit" and "Price" separate columns on the data sheet?

    thinkspi.com

  • Its on the same Sheet and 'Fruit and 'Price are separate columns


    We have to bring the output on Logic column

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    For a sheet that looks something like this:


    The formula would be:

    =INDEX($A$2:$C$4, MATCH([email protected], [Table Fruit]$2:[Table Fruit]$4, 0), MATCH([email protected], A$1:C$1, 0))

    thinkspi.com

  • Hi @Paul Newcome


    Can you help me A2:C4 refer to ?

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    The cell in the second row of Column A through the cell in the fourth row of Column C. Basically the portion of the grid that contains the H, M, and L data.

    thinkspi.com

  • Hi @Paul Newcome


    Can you please share the sheet..

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted 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?

    thinkspi.com

  • Hi @Paul Newcome

    how to autopopulate this formula for below cell...

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    AS long as there are at least two rows above and/or below the new row, the formula should auto-fill once data has been entered into the Primary Column.

    thinkspi.com

Sign In or Register to comment.