The trigger date increments weekly. The conditions date should also.
I enter notes daily throughout the week. The following Monday I want the previous weeks notes sent to X to review the previous week.
Sign in to see the current vote count, add your own vote, or leave a comment.
You should be able to set your condition to be where Date is in the Last 7 Days (or whatever number of days you want).
Correct me if my thinking is incorrect but then I would need to set up all those requests on Sunday (Saturday?) to capture the entire previous week of Sun - Sat.
Not necessarily. If you want to send it on Monday and grab the previous week of Sun - Sat you could set your condition to be within the last 8 days. You can adjust how many days in the past the condition will look at, and you can include additional conditions if needed.
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
As the smartsheet admin for Europe, it would be extremely helpful to be able to view all Automations / recurring emailed reports in one place as opposed to sheet level. It's almost impossible to ensure everything is working correctly / delete recurring emailed reports without this.
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
