If Statement

Finops C'ship

Hi Team,

Can anyone help me how to write this condition In Smartsheet

Thanks

Paul Newcome

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?

Paul 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?

Finops C'ship

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 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?

Finops C'ship

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

We have to bring the output on Logic column

Paul Newcome

For a sheet that looks something like this:

The formula would be:

=INDEX($A$2:$C$4, MATCH(Fruit@row, [Table Fruit]$2:[Table Fruit]$4, 0), MATCH(Price@row, A$1:C$1, 0))

Finops C'ship

Hi @Paul Newcome

Can you help me A2:C4 refer to ?

Paul 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.

Finops C'ship

Hi @Paul Newcome

Can you please share the sheet..

Paul Newcome

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?

Finops C'ship

Thanks @Paul Newcome

Finops C'ship

Hi @Paul Newcome

how to autopopulate this formula for below cell...

Paul 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.