-
Select a Destination Sheet - Search Function Issue
Hi All, I am in the midst of adding a "Ledger" sheet where rows from an existing sheet will be copied to each week, creating a running ledger of these updates. I added the new ledger sheet to my 22 workspaces. Now I am going through to add the automation across all existing sheets, but as I am trying to select the ledger…
-
Prevent a sent Approval Request from being used later?
I have a situation where I want to make sure some Approval Request emails cannot be used later. I have an automation triggered when a Contact List column is changed, which sends an Approval Request to the contact in that column. For some rows, a director instructed me to skip a certain person's approval as they're out on…
-
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.