# Need help with creating aging buckets.

Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over?

=LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",">30",">45",">90",">180"})

I am entering this formula in the column "Equipment Date Range" and validating the data on column "Days Onsite", for the example below all those days on site should return ">90" but currently getting an error. Any help would be appreciated.

• ✭✭✭✭✭✭

Hi Iris

Are you able to explain the logic that you are trying to achieve? Should the Equipment Date Range be returning a value of 0-7 or 7-14 etc based on the number of days between Delivery Date and Pick Up Date?

Is that what you require?

Kind regards

Debbie

(PS - without seeing the Excel sheet the formula that hasn't worked is tricky to unpick - it would be easier to find out what you need the Equipment Date Range to be returning and we can help from there)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!