-
Browse for Destination sheet in copy/move row automation
When setting up automation to copy or move a row to a destination sheet: "Select destination sheet" only gives a search bar with no browsing view of my workspaces. I have to remember the name of my sheet and type it in to be able to find it. This is a semi-new change and I very much dislike it! Can we not have BOTH the…
-
Automation - Improved "Change Cell Value" Action based on Cell Type
The "Change Cell Value" action when doing automation leaves a lot to be desired. Currently it seems to only be able to affect Text/Number, Dropdown, and Checkbox columns. There is a separate action to fill out a date for Date cells, but that is also very restrictive in that it only can enter the date of when the automation…
-
Problem with Data Shuttle that is not accepting xlsx files?
Hi All, Anyone experienced problems with Data Shuttle that it is suddenly not accepting the xlsx files from One Drive anymore? From my side when I open the file itself the section "Protect/Unprotect" sheet under Review is greyed out. Could it be that this is due to Microsoft Information Protection that I'm not able anymore…
-
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’…
