How do I get my events (recurring) to show up once a week in calendar view without manual input?
Options
NBKD
✭✭
Here is the sheet with the two meetings that occur once a week:
I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
Answers
-
The easiest way to do this is to have 3 date columns. Last Meeting, Next Meeting, and Oxt Meeting. (you really only need the Last Meeting and Next Meeting column, but I like to have 3)
In Next Meeting, put the formula =[Last Meeting]@row + 7
In Oxt Meeting, put the formula =[Last Meeting]@row + 14
Create an automation that triggers when Next Meeting is reached. The automation will be to record the current date in the Last Meeting column.
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!