-
How to best pull data from a matrixed sheet of dates and milestones into a project sheet?
I have a team that is updating date estimates in a large sheet. I'm looking to create a project sheet from that matrix/range. I'd like generate the sheet with links at the same time so that when the team revises dates in their sheet the project sheet updates as well. I don't want to have to manually create Column A entries…
-
Cross Sheet Joining Automation
Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox that initiates a purchase request next to each item. My initial stab at this is when…
-
Auto create unique IDs for both Parent and Child Rows for Test Scripts
Help with logic for Test Script auto creation of the Test Case ID (Parent) and Step Number. Since this is Parent / Child the Column properties for auto / number system will not work. Step Number: I created formula to auto generate step number ID by looking at the Step Details column and if the cell in row has any text/data…
-
Automatic Finish date and Finish time columns for a 3D Printer Sheet
Hello everyone, I am creating a sheet for my 3D Printer and I need some help as I am new in Smartsheet and in using functions. I want to make the "Finish Date" and "Finish Time" automatic, meaning once I input the Start date, start time and duration, the Finish date and finish time will automatically show when my 3d print…
-
Data Shuttle - trigger workflows with new row in sheet
Evening all. Problem that I have is that I need a dynamic dropdown working between two sheets (i.e. values in column X in sheet 1 should be dropdown options in column Y in sheet 2). I've figured out how to do a workaround using Data Shuttle (offload workflow from sheet 1 to a Smartsheet attachment CSV, update dropdown in…
-
Automation script not working
When I change my Status column to Cancelled the specified cells do not clear. So what have I done wrong?
-
Off-line Client / Integration or Workflow Recommendations for Smartsheet
My very short question is: After researching that Smartsheet does not offer a desktop client or offline mode, are there any software solutions on the market that offer an integration from Smartsheet to a client based application; or perhaps a workflow you've worked out for offline users? Our Story Smartsheet became an…
-
Gantt Chart Parent Row Bars
Has there been an update to allow color edit to the gantt chart parent row bars? Thanks - Julie
-
Automation
I am working on developing a form and sheet for a patient safety survey. Each individual question has 6 possible response options with a corresponding numerical value eg "Strongly Disagree" will = 1. Is there a way to develop an automation that will change every "Strongly Disagree" response IN THE SHEET to a value of 1? Or…
-
Creating a SEARCH Box on Dashboard
i. I have no idea if what I am after is possible. I have a sheet that I would like displayed on a DASH but the option to type the name of the company you need and have that information be produced for the user. Would like to set up something similar to a form so you can type the name of the company and the rest of the…