What is missing from the below if formula?


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


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    The reference to the cell is not correct.

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

    You need [column name]@row


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!