-
Trigger approval request based on submitter info
My org's travel request form goes through two approvals, first the submitter's direct supervisor approves, then the COO approves. I know I can have the form submitter choose their supervisor from a list of approvers on the form to trigger the first approval request that way. Is there a way to omit that step from the form…
-
Separate Automations from Safe Sharing
At this time, Safe Sharing also restricts automation emails to only the emails added to the safe list. https://help.smartsheet.com/articles/855284-security-controls-enterprise-only Wishing we could separate this: We have use cases where we do not want to share a sheet with a 3rd party, but we still need to send them…
-
Include Column Origin in Properties
This request stems from my copying and moving rows from sheet to sheet. It would be very helpful for me to click on a column and see where the column originated from (Sheet name). If it was copied/moved and carried over from a different sheet, or if it was created within the current sheet. I'm running into very frustrating…
-
Automation that alternates assigned contacts each time a row is created
I'm trying to figure out how to create an automation or formula where it will automatically assign from two or more contacts when a new row is created. It would also need to alternate or go to the next contact in a list. For example, I have an "Assigned to" column and in that column would be 2 names (A and B) and when a…
-
can you set up weekly reminders for a date that has gone in the past (off a cell in the sheet)
Im looking to set up a reminder automation that will send out reminders on a weekly basis if tasks are not completed by a certain date. In my sheet there are numerous dates and they are pulled in from formula (dynamic) meaning that i need to pull it off a specific column / cell in the sheet. although the automations allow…
-
Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
-
Merged: Lock Specific Cells
This discussion has been merged.
-
Data Shuttle - Notifications if Unique ID is Missing?
Hi all! I'm setting up a data shuttle to automatically update our records when we receive inventory reports from a third party vendor who manages our warehouse. The trouble is, we've noticed that some of our items have fallen off their reports, and we need to keep an eye on this week over week. I'm trying to see if there…
-
Scheduling Emails
I am running automations to send emails when text or a checkbox is active in a cell sending row information to different people, there are no attachments on these emails. I would like to know if I can schedule the emails that are triggered for once or twice a day. This will allow for fewer emails when a lot of rows are…
-
Auto-Assign Task in Board View Based on Filtered Individual
Hi everyone, I’m looking for a way to automatically assign tasks to an individual when a new task is added in Board View and a filter is already set for that person. For example: • I have my Board View grouped by Assigned To. • If I filter the board to only show tasks assigned to me, and then I add a new task, I’d like…