-
Chart rounding on dashboard
This discussion was created from comments split from: Metric chart - Pie chart - % update.
-
Self-Contained Process Management
Hello all! Wanted to share that I've had several success stories using Smartsheet as a process tool that is self-contained with high visibility for every point within a process with nearly 0% process leakage. I use Smartsheet internally for change management engagement tracking, task tracking within a specific engagement,…
-
Counting value repeats since last distinct value
Hi Smartsheet experts! I'm trying to accomplish something like the above, where I count the number of repeats of one value in a column, but that count resets when the value changes and resets to 1 if the same name appears later. This is to consolidate an order form where users can order different numbers of items- it's…
-
I have a complex sheet that uses a lot of mapping to documents in multiple languages and I need ideas for workflow
Ok, so the use case is as follows. Our Employee fills out a Smartsheet form for the client that then generates multiple documents, based on selections the employee makes. These documents are in the language selected by the Employee. I then need the client to be able to electronically sign the documents and return them.…
-
Copy attachment from one sheet to another
It would be helpful to have a way (with a formula using cross sheet references or via an automation) to copy an attachment from one sheet to another. For example, I have a Master Project List with a scan of the project paperwork attached, but would like it to copy to the Project Metrics sheet also.
-
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…
-
Preserve original formatting in automated alerts
Dear Smartsheet team, I found that the automatically generated table by Smartsheet and incorporated to email (generated as a part of Alert someone automation workflow) for some reason lost the formatting of cell, f.i. if on the original Smartsheet webpage the cell is colored in green and text is bold in email I see regular…
-
Set Default Value in Form that is NOT a Dropdown Value
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…
-
Form Security Permission Setting
Our company has found that form submissions are not as secure as we need them to be. Anyone with the form link can submit an item that posts to the source sheet regardless of security permissions. In essence, with the link, Customer X can post an item to Customer Y's sheet. Please consider adding another level of form…
-
helper row and determining the earlier of 2 finish dates
Hello, I have task 3 which is dependent on task 2 and task 1. I want task 3 to start when either task 2 or task 1 is completed. How do i implement this in Smartsheet gov? below is a screenshot of what I tried but it does not seem to work. Any suggestions?