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.


Best Answer

Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭

    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)