Help with a formula
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
Answers
-
Is this best done using a formula such as countif, or a report?
Any help is appreciated!
-
It depends on how you want this information displayed.
-
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.
-
In that case I would suggest a COUNTIFS.
What does your sheet look like?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!