-
Automated Sort in Sheet
Is it possible to create an automation that sorts the rows automatically when changes are saved? For example, if my sheet is sorted by Column "Stage" Numerically Increasing, and I insert a row, fill it in, and save it, I want the sheet to re-sort to incorporate that added row in its proper location. Thank you!
-
Auto-sort using API
I understand that as of now it is not possible to auto-sort columns in Smartsheet. But is there an API code that can be used to sort columns alphabetically?
-
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…
-
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…