Formula Assistance

cbonnell

Hello Everyone,

I need assistance creating a formula that will give the sum of every fifth cell in a single column.

Schiff A.

Hi cbonnell!

 

In order to best assist you I'd like to understand a bit more about your use case and how your sheet is organized. There may be a better solution than using to calculate a sum of every 5th cell in a column.



For example, you may be able to take advantage of row hierarchy and the hierarchy functions (CHILDREN, PARENT, ANCESTORS) to create rollups.

See these articles for more information:



https://help.smartsheet.com/functions

https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows

Thanks,

Schiff