Date Sequencing
Hello. Can someone please help? I'm trying to auto insert/sequence a series of dates between two different dates in two different cells. If Date1 is 1/15/24 and Date2 is 2/8/24 Id like a third cell list the two dates and all dates in between on individual consecutive rows.
Answers
-
I am not certain that there is a way to do this natively inside of Smartsheet. There are zero formulas that I can think of. You might have to go to an exterior program to perform this action.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!