Auto Sequence by Date?

Amy Scherer
Amy Scherer ✭✭
edited 04/12/24 in Formulas and Functions

Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date column? In other words, if I have 10 projects with 10 dates, can Smartsheet apply a value in my "Order" column based on the dates in the "Due Date" column?

Thank you for any guidance you can provide!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!