Formula to auto fill cell's in a column going downward in a row.

Hello

I am looking for a formula that will autofill totals in column5 going downward in a row so filling column5 row 1, row2, row3, etc. The information comes directly from Column2 automatically and gets filled weekly with different data. Please see image.

All feedback is welcomed.

Thanks again.

Answers

  • Cristian
    Cristian ✭✭✭✭

    This is the formula I am using in to total the amount in column 2 =COUNT([Column2]:[Column2])

  • Hi @Cristian

    Formulas assess current information and aren't able to time-stamp or pause a result at a specific point. This means that when Data Shuttle updates the sheet, the formula will update to reflect the new information.

    If you're on an Enterprise plan, you could look into using the Work Insights panel to track changes to data over time in the sheet. You could have a Time Series chart based on Column 2 to see how many 1's are in that column week over week or month over month, etc. See: Use Work Insights to visualize your data.

    Let me know if that will work for you!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!