Reference cell to the left of the current cell

Can anyone come up with a way to reference the cell to the immediate left of the current cell without having to specify the column name to the left?


  • Jen Lange
    Jen Lange ✭✭✭✭✭

    @Rob Oaks , what are you trying to accomplish that requires you not to reference the column name?

  • I have about a dozen pairs of alternating %/Hours columns as show below. The Hours column formula always referes to the % column formula to its left. They are all configured as column formulas.

    I was hoping to just use the same column formula in all of the Hours columns.

    Silly me, however, as I just realized that I could just create a cell formula in the first Hours column, copy it to the other Hours columns, and _then_ convert them all to column formulas. In that way, the % column references, which are relative, are automatically updated as I copy.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!