-
Team Vacation Planner - automation to notify if too many people are taking the same day off
Hi there! Is there any way smartsheet can set up an automation that if there are too many people taking the same day off it'll send an alert to me? I have a start date and end date column I also have another helper sheet with each day (excluding holiday, Saturday and Sunday) in each row and different departments as column.…
-
Are you able to resend updates request that were triggered by an automation?
I have users that misplaced or lost their update request email in Outlook and they want me to re-send them the link to update their specific projects. I know I can do it manually per each project but that will take some time to resend those out. Looking for an easier way. Is this possible to resend the original email I…
-
Record a date in deadline field when resource management is on
Hello all I have a request form that works great and I am using it for resource management as well. This means I have start date, deadline and duration. Initially when I receive a request I manually put the start date and deadline. Sometime my team finishes a task "early" and the workload will still show up in their…
-
How to send 1 approval request email for multiple items?
Hello Smartsheet Community! I have a list of 40 items that I want to send to stakeholders to either approve or decline. This will be used as a voting system, where the items that get the most approvals advance to the next step in a process. When I have used the UPDATE request workflow in the past, the recipients got 1…
-
Trigger a daily automation if a record doesn't exist
Hi there, Our warehouse leads use a smartsheet form to upload a document once a day, around noon. I want to have a notification sent to the manager of a warehouse if that warehouse didn't upload a file for that day. The sheet that the form is built on looks like this: DC is the warehouse number. The formula works for…
-
Separate form submissions from reference data
I've imported a CSV File into Smartsheet that serves as my database repository for Form Fields. My Form is created on this sheet in order to reference data values within the grid for multi-select form responses, which are limited to the values provided. I would like for form submissions to land on a separate sheet as my…
-
Due date automation - how can I do this?
I'm working on a project to automate the flow of processing between multiple staff, each task will have 1-3 days to process [due date] depending on the task. Is there a way to assign the due date through the automation process? I have it assigning when the previous person has completed their task, but I'm not seeing how to…
-
Google Sheets integration - automatically updating cells in GSheet when SS is updated?
Hello! I'm looking for a way to automatically update cells in Google sheets, when a cell in Smartsheet is updated. For example, if a Date changes in Smartsheet, Cell C4 in google sheets would update to the new date. Is this doable? Thank you!
-
Need a formula to have all work-flowed moved cells to go to the top of the sheet
Every time I put an automation to move cells to another sheet, they end up at the bottom of the new sheet. Is there a formula I can use so that they can start coming in at the top? Thank you!
-
Automation Notification email issue
Hello. Does anyone knows if there is a way to modify the Automation notifications to come out from a vanity email like " NO_REPLY@Company Name.com instead of the name of the person that setup the automation? Im getting seveal people reaching out to me thinking that I manually sent them the email asking for updates.