Formula for recurring event (daily and weekly)
MirandaLang
✭✭✭✭
Hello, I am generating a sheet to link to the calendar app and am trying to limit the amount of work needed on the backend.
 I have a daily check in I want listed in the sheet so that it is visible on the calendar app but want to avoid having to manually select each day for the next 6 months. Is there an automation or formula that I can use so that it auto populates sequential dates?
 Similar situation, I have a meeting that occurs every Friday and want to eliminate having to manually enter each friday's date for the next 6 months. Again, is there an automation or formula I can use to do this?
Best Answer

Hello @MirandaLang
 Autopopulating sequential dates:
 Start by entering the initial date in a cell. For example, let's assume you enter the initial date in cell A2.
 In the cell below it (A3), use the following formula to automatically populate the next sequential date:
=A2 + 1
.  Copy the formula in cell A3 and paste it down the column. Smartsheet will automatically increment the date by 1 for each row, populating sequential dates.
 Recurring meetings on Fridays:
 Enter the initial date of the first Friday in a cell. Let's assume you enter the initial date in cell B2.
 In the cell below it (B3), use the following formula to calculate the next Friday's date:
=B2 + 7
.  Copy the formula in cell B3 and paste it down the column. Smartsheet will automatically add 7 days to each previous Friday, generating the next dates for the recurring meetings.
By using these formulas, you can avoid the manual entry of each day or recurring date for the next 6 months. Smartsheet will calculate the dates automatically based on the initial date and formula you provide.
HTH!
 Autopopulating sequential dates:
Answers

Hello @MirandaLang
 Autopopulating sequential dates:
 Start by entering the initial date in a cell. For example, let's assume you enter the initial date in cell A2.
 In the cell below it (A3), use the following formula to automatically populate the next sequential date:
=A2 + 1
.  Copy the formula in cell A3 and paste it down the column. Smartsheet will automatically increment the date by 1 for each row, populating sequential dates.
 Recurring meetings on Fridays:
 Enter the initial date of the first Friday in a cell. Let's assume you enter the initial date in cell B2.
 In the cell below it (B3), use the following formula to calculate the next Friday's date:
=B2 + 7
.  Copy the formula in cell B3 and paste it down the column. Smartsheet will automatically add 7 days to each previous Friday, generating the next dates for the recurring meetings.
By using these formulas, you can avoid the manual entry of each day or recurring date for the next 6 months. Smartsheet will calculate the dates automatically based on the initial date and formula you provide.
HTH!
 Autopopulating sequential dates:

Thank you do much for the tip! It worked perfectly!
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives