-
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…
-
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.
-
Auto-Numbering Automation
Can you add a feature that auto-numbers a row based on an automation criteria (i.e.: Provides the next number in the list when an automation is approved) Love the auto-number feature, however it is not always practical to have every row numbered.
-
How to summarize the message for an automation with multiple rows
Hello, I built an automation that runs on a daily basis based on some parameters. The message sent with the automation duplicates for each row that is included in the email notification. How can I avoid having multiple messages but only one message at the beginning ?
