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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!