-
Can an automation send particular cell information and not access to an entire column?
We have projects set up in our Workspace. At the top of each sheet is Summary information from within the sheet and it's linking out to source sheets as well as information is pulling into the sheet from other sources. This is set globally through Control Center when a project is created. I would like to create an…
-
Automations for time based requirements
Currently we can only use filter expressions and automation that are based on current day or previous day etc. Why can't we filter by past hours or other similar terms? It would add so much functionality to Smartsheet in its various functions, such as project for one when assigning task durations by hours or to filter…
-
Help for Status Change and Tracking
I am trying to create dashboard widgets from data that I am tracking. For this widget I am wanting to have a graph show the number of people in each status section I have listed: "Not Started", "In Progress" and "Completed". Each employee has an individual sheet with tasks listed along with corresponding start/end dates,…
-
Issue with row "new event" trigger
Hi there, I am using make.com (formerly integromat) to update an external database whenever a row in my smartsheet is updated. The automation is set up so that whenever a row is updated, I get the row (all of the cells) and then send that data to update my database. I only need this to trigger when a cell value is changed.…
-
Email being sent before Approval Request is answered?
I've set up automations based off of the type of request, division, division head, etc. The automation. The Trigger is when rows are added and when the Type of Request (in this case) is a PO, there is a stacked condition of when the Division is "Admin" and where the Contract is "No" When these conditions are met the…
-
Can you copy specific rows to a new sheet without bringing over child rows?
We do our weekly reports (Good, Brutal Facts, and Help Needed) within SmartSheet (Have 5 levels of Hierarchy with "+" and "-" icons), and our process has gained traction with other teams. We are looking at how to scale our process to accommodate another level of leader (Currently goes from Managers -> Director and Director…
-
Formula to auto-summarise Delivery Risk assessment
Hi all, I'm attempting to build a function into my master milestone tracking sheet which will auto-populate my ‘Delivery Risk’ column, based on a series of conditions met in other cells in the row. Underpinning thinking is as follows: ‘Target Milestone Date’ are set for every row Assumption that ‘Actual Completion Date’…
-
Update Sheet Summary with Automations
It would be very convenient if we were able to do update requests and cell changes via automation for the sheet summary section. Right now it's out on it's own and forced everything to be done manually. Limits the effectiveness of the tool. For example, we keep "Status" in the sheet summary, and I want to be able to update…
-
Record a date on the start date field when the status's changed
Hi Smartsheet Help Team, When the status's changed to in progress, I want to set up the automation and record the date in the start date column and when it's completed, record the date in the end date column. However, it's said there are no date columns, but I have the start date and end date columns (see below). Do you…
-
Smartsheet Update Request Automation to Alias Email Address
We are running a automation for an update request to a number of email addresses and it runs fine with the exception of two which happen to be alias email addresses. Has anyone had this issue with them not running and know how to fix it? We after the automation didn't run we ran the update request manually and it ran as…
