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?


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


  • 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


    (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)