Sum numbers pulled out of other columns

Leeba Z.

Formula is not allowing me to add 1 to column that contains a number which was pulled from another column:

Column one: Week 15

Column two: =right([column one]@row, 2) - this will pull out the 15

Column three: I am trying to add 1 to the 15 from column 2, the formula is not working (=[column 2]@row + 1) it is just adding a 1 to the text string and giving result of 151 instead of 16 which I want.

Leibel S

@Leeba Z.

Add the VALUE function to your column one formula:

=VALUE(right([column one]@row, 2))

Melissa Yamada

Hello @Leeba Z.

In addition to @Leibel S you can shorten the formula and use only 2 columns:

Column 1: Week 15

Column 2: =VALUE(RIGHT([Column 1]@row, 2)) + 1

-or-

Stick to what you have:

Column 1: Week 15

Column 2: =RIGHT([Column 1]@row, 2)

Column 3: =VALUE([Column 2]@row) + 1