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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!