Find next entry date

Hi all,

I'm currently trying to figure a formula that would find the next entered date for specific tools from my Rental Out column to populate the Rental In column. We have a system that tracks the movement of our tools and I'd like to find the next date entered by specific tools to track the duration the tool was on certain sites.

For example, row 7 Hammer, the Rental In would be 02/07/21 which corresponds to the next entered date for the hammer. Row 6 Ladder, Rental In would be 23/06/21, row 5 Rental In would be 29/06/21, etc.

Any ideas?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!