-
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…
-
Enable Datalink from other Smartsheet for Dropdown list (for Multi and Single Selection)
Dear Sir/Madam, Kindly request you to add or enable datalink option in Dropdown list which helpful smartsheet users to update the Dropdown data in one place and utilize it all dropdown list. Thanks for prompt support. Best regards.
-
Referencing Values While Using Workflows and other grievances
There is some serious disconnect between Workflows and Formulas/Functions. I use Smartsheet mostly for task management on a small software development team. When we submit a code change it must go through multiple steps in this case: Development, Testing, Code Merge, and a few other tasks. I want to create a form that…
-
How to export data to Excel without overwriting previously exported data.
Howdy! I have built a very robust sheet for collecting form submissions company-wide. We are currently maxing out our sheet cells every two months and I'm having to manually copy/paste the data to a running excel file that our Analytics team uses to connect with PowerBI. Can I set up an excel sheet that just pulls 'new…
-
Turn Cell Formula into Column Formula
Hello everyone! I am at the beginning of making some operations sheets for my job and will need to rely on column formulas I have successfully input a formula in a cell and it works! When I drag the formula down, it works. However, when I try to convert it to a column formula I get the error saying that the syntax is not…
-
Copying Date to Text Cell
Hi everyone, Is there any way for a formula or automation workflow to automatically copy/insert a date into a text cell? I'm trying to create a formula where if the STATUS column is "DATE" it will then Copy the date the item was created into a text Column. Is this possible? Thanks!
