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…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
