Open-ended column on another sheet

I am using SUM referencing a column on another sheet and I want to get that column to be Open-Ended (so that when new rows are added to the other sheet, they will be automatically be in the new total on my sheet).


I am adding Hours from a time card sheet. When I stay on the that time-card sheet, Open-ended is easy to do: "=SUM(Hours:Hours)" and any added row is automatically integrated to the total.

But when referencing another sheet, the only option I am given is range of rows and the entry is like "=SUM({Bob's Time Card})"  

So, how can I edit the reference to the other sheet to override the range? 



  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi Philippe,

    You're on the right track with =SUM({Bob's Time Card})

    What you'll want to do is edit the reference and then in the column you're storing your hours in on your timecard sheet, instead of highlighting the visible rows, click on the column header. This will ensure that not only all the rows in the column are referenced, but that any new rows will also be included.

    Kind regards,

    Chris McKay

  • philippejj0421
    edited 05/09/18

    Thanks Chris!

    That worked!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!