Can I set up recurring items in a calendar like a monthly newsletter or does each instance require a manual entry?
Hi @Patty Stewart
If you're wanting to add tasks to the Calendar View of your sheet in Smartsheet, then each entry will need to be present as a row in the sheet. Although this does mean that each instance requires an entry into the sheet / its own row, you can easily create patterns with a date field by using drag-fill (see here).
For example, if you wanted the date to occur every Monday, fill in two rows with two Mondays in a row. Then select both those cells, and use drag-fill to fill in the dates in the rows below. This will auto-fill using the pattern you set up in the first two rows (Mondays, one week apart), and will update the rest of the rows with the next Mondays
Now, if there is only one task that needs to be updated each week, you could potentially build a formula into that Date cell in order to have it update each week to a different day of the week, depending on what date today is, but then the task would only ever appear once in your Calendar, and it would change location/date each week.
Let me know if this makes sense or if you have any more questions!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.