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.
Formula to include new data added to my sheet
I have set up a formula that works very well however it isn't taking into account new entries added to my sheet. For example my formula is on Row 1 under the column 'total' I then have other information in rows 2-15 so therefore my formula on Row 1 starts from row 16 to give me the total I want into Row 1. My formula in row 1 is =SUM(total16:total18) this works fine for the data I have at the moment because I only have three lines of data (rows 16-18) however when I add in data to row 19 it obviously isn't included in the total in row 1. It wont allow me to make the formula open ended so that any new data is included in the formula. Any thoughts?
Many thanks, Irene