What is missing from the below if formula?

Options

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

Tags:

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!