-
Possible to automate numbers per row type?
I am adding a PO system in our smartsheet that holds different types of financial tracking. I want to auto populate new PO numbers, however, only for a row if a different column is marked as "PO Request." Is this possible? Currently the autonumbering feature does all rows. I've tried the following column formula so that if…
-
Form auto-sent to inbox with autoreply ticket email. Can that email get back to form submitter?
I created a form that is filled out and submitted by a wide range of internal users that includes their email address. Once submitted the form auto-sends to an IT support inbox in Outlook that immediately sends an autoreply with a ticket number related email. Is there a way to have that autoreply go directly to the email…
-
Proposal Project Creation
We are slowly implementing Smartsheet from Trello and have a few questions on how to automate this to make it easier. We use a Form for our Coordinators to fill out information (RFP Name, due date, exceptions due...) so that this can be added automatically to a master list of RFPs for the year. With this, is it possible,…
-
Automation based on Sheet Summary
Can I set up an automation based on a field in a sheet summary? What I'm ultimately trying to do is set up a review/approval workflow for an entire spreadsheet. Everything I've tried so far (adding status column to the sheet, using a separate summary sheet to track approvals, etc) has been fairly clunky for our team so I'm…
-
Improved search for move/copy row automations
When setting up a move/copy row automations it would be helpful to be able to search through workspaces, rather than having a blank search bar. For templated assets it can be difficult to identify which one to select. Here's an example: A navigator, such as when selecting a source sheet for a report, or setting up a…
-
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…
-
When a form is submitted I want to add 3 children task underneath each request
Hi, How can I achieve when a request is submitted I want to add 3 children task underneath it. so that when ever the request is submitted I have predefined user task(repetetive same)task that needs to be completed Thank you in Advance. Thanks, Radhika
-
Why does my simple flow not working ?
I have created a simple flow that whenever an input is reached the sheet through a form, an email has to be triggered to the sender as an acknowledgement. This was working for some time and now this is completely stopped working. It doesn’t respond event when i trigger this manually from the workflow screen.. Any idea?
-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
-
Add Run on Attachment for DataTable in DataShuttle
Please include a run on attachment option for DataTable in Data Shuttle. A daily up to weekly only option is very limited. We also need monthly, bi monthly, etc. Similar to the custom date automation option in Smartsheet sheets.
