-
Bounced Automated Emails
It would be super useful to be able to get a notification to the default email address for your account when an automated email gets bounced back (due to a bad email address, for example). I know that an 'email undeliverable' message is sent back to you when you try and send an email to a deactivated or invalid address, so…
-
Email automation with PARENT/CHILD data from pivot table
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…
-
Upload Thousands of Excel Documents to Rows
I have been building a workspace for inspection tracking. Before this we were utilizing an Excel doc that would use a macro to create a new Excel doc for each inspection with the information that was entered. There are 2332 excel documents. The information in each doc are not in individual columns. The filenames are Asset#…
-
Copy row with no hierarchy on one sheet and make it a child on another.
I have a been working on building a asset inspection tracking workspace. I currently have 4 sheets built for it. The first, Asset Master List, has all of the assets and information about the asset built into it. This sheet was built from an Excel Import. The second sheet, Inspection Form, has all of the form responses for…
-
Custom Serial Numbers
Hi there! I want to be able to assign a unique serial number to each newly populated row. One of the columns, "Type", determines the first letter of the serial number for the respective row - the prefix - and the suffix is a three digit number (starting at 001) that increments by 1 determined by the prefix. For example: In…
-
New to Smartsheet Tips?
Just started a new job. Company is new to smart sheet. Right now I work in data entry and basic automation. Eventually working towards full processes and product creation. Does anyone have any tips or tricks that I should know to help work through it. So far I enjoy using smart sheet and would like to learn more.
-
Merged: Automation Action to calculate a Variable Value
This discussion has been merged.
-
Do formulas not work in automation?
I'm trying to make new rows copy the cell in a column under a parent but this doesn't seem to function. Am I missing something? When I run this, it posts '=Parent() which doesn't help me.
-
Providing email response to submitter of a form
I want to set up an automation to email data collected in form to the person who submitted the form (I collect their email in the form).
-
Automation - include dynamic info from fields without losing single update request functionality
Hi! I'm looking at using Smartsheet for client SLA reporting I need to gather data from my team(s) per client, per market. I'm using automation to request an update (as below) I'd like to make use of the the {{ }} part of the automated email body, to indicate the client and the market specified as below, so I don't have to…
