Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Entire Row Reference in Formula

Gary Singer
Gary Singer ✭
edited 12/09/19 in Archived 2016 Posts

Is there a way to reference an entire row in a formula? I'm trying to count check boxes across an entire row, but don't want to re-write my formula if I add a column. 

 

Thank you! 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Gary Singer
    Gary Singer ✭
    edited 02/05/16

    I found a way to do it, I just referenced a range of cells in the row. I just have to make sure I insert rows to the right of my last column. 

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    Happy to hear you figured it out! When you select a row range in a formula, inserting a column within that range will include the new column in the formula. But, inserting a column outside of the range will not include the new column in the formula. 

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories