-
Make Hiding & Unhiding columns an Automation function
Perhaps my "search foo" is a bit rusty, but I could not find an existing suggestion for this specific issue, only several tangentially related suggestions. I believe this is pretty self-explanatory. I have sheets with several checkbox columns that are typically hidden, but often need to be unhidden to perform some action.…
-
Is there a way to automate sorting rows by date?
We have several sheets that require users to update the Next Review Date a year out. Then we have to manually sort so that the tasks are in ascending order. Is there a way to automate this currently? Or some sort of work around that I can use?
-
Automation not displaying sheet I'd like to move rows to
I've had this issue before and still continue to have this issue where a sheet that I create (for archive purposes) is not displaying in the automations for me to move rows to. I created this sheet last Friday and it's Monday now, and the sheet is not displaying. Does anyone know why this is? This isn't the first time this…
-
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…
-
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…