Help with a formula

Mark McLean

I am developing an equipment tracking smartsheet.  One of the columns indicates the estimated lead time for delivery.  I would like to "bucket" the lead times into ranges:  0-60, 61-90, 91-120...etc.

Thoughts on how to best achieve this?

THANKS!

Mark

Mark McLean

Is this best done using a formula such as countif, or a report? 

Any help is appreciated!

Paul Newcome

It depends on how you want this information displayed.

Mark McLean

My thought is the display would be a table.

left column would be the categories, right would be the number of lines in each category.

Paul Newcome

In that case I would suggest a COUNTIFS.

What does your sheet look like?