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
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! 



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

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

This discussion has been closed.