nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Formula Assistance

cbonnell

Hello Everyone,

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

Comments

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

CanadaJim

Just throwing this out there:

You can always have a new extra column that repeatedly counts 1-5

=IF(CountCellAbove=5,1,CountCellAbove + 1)

Then your Sum formula can be:

=IF(CountCellCurrentRow=5,SumCellAbove+CurrentRowValue,SumCellAbove)

If you need more help understanding what I mean, let me know.

Jim