What is missing from the below if formula?

CALBERT

=if(@row23 = Y, "0.1", "0")

I am wanting Smartsheet to put 0.1 in a cell if the reference cell is a Y and 0 if the reference cell is a N.

KPH

The reference to the cell is not correct.

=if(@row23 = Y, "0.1", "0")

You need [column name]@row

or

[colunm name]23 if you are referring to row 23.

You also need to change how you are using quote marks. Put these around the text and not the numbers.

KPH

The reference to the cell is not correct.

=if(@row23 = Y, "0.1", "0")

You need [column name]@row

or

[colunm name]23 if you are referring to row 23.

You also need to change how you are using quote marks. Put these around the text and not the numbers.

CALBERT

Thank you so much, that has solved my issue!

KPH

Wonderful. Glad I could help.