-
Using Automation to send single sheet email request, rather than multiple emails
Currently my automation is used to update my users once weekly to update any of their rows with the a cell marked 'Open'. This sends anyone with 8+ cells a single email spreadsheet of the applicable rows that they can review and then update as needed. To everyone else this is spamming six emails to update each row…
-
Form Notification - Email Address
Hi, I have created a Smartsheet's form with an automated process behind it that sends approval requests based on certain criteria. Is there a way to change the naming on the email that people receive so instead of people receiving it as Name via Smartsheet <automation@app.smartsheet.com> the name could differ. I would…
-
SmartSheet Alert Mail Sender
Hi all, I am the owner of 10 sheets each of one is used by different users. I have set up alerts automation but when the email is sent, it is always shown my email address instead of that of the user. This is a problem as the email is sent to external customers who are always receiving email from me and not from the…
-
Novice - Date Status Changed
I want to track when a project changes Status. I'm primarily using the Card View and want the date the Status changes or the project switches swim lanes, to have that day's date. For example: Old Status: Reviewed Date: 10/19/2020 New Status: Completed New Date: [Date Status was changed]
-
how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?
Thank you for your time. I cant find the answer in the documentation or forum. So I am asking. a. How do I reference a single cell in an external sheet? b. Can I reference a cell by row number and column number? c. Is there a way to make this dynamic? using the ' =ExampleCell1 ' syntax is for the current sheet. How would I…
-
Random Updates - Cell History
Hi, we've been using a format where once a form is submitted, a row is copied to another "master" sheet that the team can manage off of. Recently, I've made some changes to the process (around when the copying happens), but what we're seeing is that in our Master sheet, there are random updates to cells (we have alerts set…
-
How do I make formulas automatically carry down to the next line when a new form is submitted?
I have a sheet that is being fed by a form. I am using a vlookup to add contact data from another sheet dependent on the email of the person who submitted the form. I want those vlookups to be added automatically to each line as new forms are submitted. How do I do this?
-
Automate checking a box if date column is less than 2 weeks?
I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date. What would the formula be? Thank you!
-
Using Workflows to Populate Cell Values
Hi, I'm trying to use workflows to auto-populate a Date Column. Example: When "Work Order State" changes to "Scheduled" populate a system time-stamp in "Scheduled Date". Is this possible? Thanks, Quinn
-
% Complete in Project Template seems to be off.
Working in a Smartsheet Project Template. I've put in my % complete info for each WSB row. The Parent % complete is reporting back 21%, while a selection of the rows shows that the average should be 19% Does anyone have a logical explanation for this?