Defining a range using a variable as the row #

Hi,

Newbie question here.

Let's say we have a simple SUM formula:

=SUM([Column1]15:[Column4]15)

Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell?

For example, rather than "15", something like

=SUM([Column1]Row:[Column4]Row)

where "Row" could be sourced from the number value in a cell?

Thanks in advance for the help.

(this would be to SUM different rows as they are added through a form, and have the SUM of the most recently added row always appear in one particular cell)

Comments

  • Hi Paul,

    There currently isn't a way to create a cell reference from concatenated values like this. When you have a moment, please submit an enhancement request using the Product Enhancement Form under Quick links on the right of the community site and let our Product team know you'd like to see this feature added.

  • Ok, thanks for clarifying.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Paul,

    If the number you are wanting to reference (like a Row Number, but one that you have created), then

    - take a look at LOOKUP() ... sorry VLOOKUP() 

    or

    - use SUMIFS() with that number as part of your criteria.

    Both have worked for me, depending on the exact use-case.

    Craig

     

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!