-
Changing the name of Sender - Emails?
Good Afternoon Smartsheet Community, How can I change the Sender name of the emails? Currently its saying "my fullname" via smartsheet automation@app.smartsheet.com" I don't want my name displayed in all the emails it's sending as I currently create reports.. so every report automation it sends it out as if I am sending it…
-
What happens when a trigger is linked to two automations?
I have two automations. 1) One automation is triggered when "Dropdown" changes to any value. When the automation is triggered the effect is different depending on the conditions in the automation. If "Checkbox" is checked then certain cell changes happen, if it is NOT checked, different cell changes happen. 2) The second…
-
Increment Conditions date(s) along with Trigger date
The trigger date increments weekly. The conditions date should also. I enter notes daily throughout the week. The following Monday I want the previous weeks notes sent to X to review the previous week.
-
Autofill cells based on data in other cells
Is there a way to autofill a cell using data from other cells as a trigger? For example, our projects are assigned a number (MonthNumber) in one cell, and we have a another cell that says Month. This serves two purposes for us - the count the projects per month but also to indicate what data to pull for our reports. Is…
-
Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive. Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet. Is there a way to use Power Automate to run the…
-
What is the time gap used to consolidate the changes made on the sheet and send a single alert email
Eg: I have a automation alert which is when a cell is changed to "Yes" for one of the column on the sheet alert me. I updated corresponding column in row 1 to "Yes" and saved the sheet. Then immediately updated the second row to "Yes" and again saved the sheet. I received one email with details of these two rows. At what…
-
Workflow Not Working
I have a workflow to copy rows to another sheet if a checkbox is checked (the checkbox column has a formula in it to make it checked depending on another cell). Please see the attached images for what the setup looks like. The rows are all pre-populated due to formulas required in each to calculate out information. That's…
-
Is there a way to include the Sheet Name as a variable in a message?
Based on this KB article (Dynamically Add Cell Data in the Subject and Body of Request Messages) I know that we can include the names of columns (like {{Name}}), but I want to update the subject to include the name of the sheet itself (like {{Sheet_Name}}. Context: We have created a contact list template, that has a form…
-
Managing Change Requests on existing portfolio of projects
Situation: about 85 projects in a portfolio. As PMO, want a simple tool for project managers to submit change requests for major changes to their projects, principally to request a change to end date and provide a rationale for why the date needs to change. Ideally, a link from the project plan that allows a form pop-up to…
-
Issue with Smartsheet Cell Limit - Data Shuttle
I'm trying to use Data Shuttle to import data into a Sheet upon attachment of an Excel workbook to the same sheet. When I attempt to run this Data Shuttle, I am getting an error that I have exceeded the 500,000 cell limit. The parameters of my source Excel sheet are as follows: Cells: 401,668 Columns: 40 Rows: 10,280 I…
