-
Automations question
I was helping a co-worker convert an Excel file to Smartsheet. One of the things she currently does manually is after entering new rows onto her Master file; she copies (manually) to each of the QMS Entities sheets. Now there are about 20 QMS entities. We looked at the Copy to sheet template automation, but it appears as…
-
How to automatically check a parent row when children are checked?
Hi, I have 3 level parent-children rows. I also have a column with a checkbox. Is there a formula or automation that would check the parent row if all children are checked?
-
Automation in Preventative Maintenence
Hey all, I'm trying to get it so that I have a recurring input every 4 weeks on the next open row? I'm using a template and I've got a linking column that identifies following the approval that a line is completed to lock and set the date for the row. Is it possible to take the task again move the start and end date by 31…
-
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…