-
# of Tasks Assigned to Each Person from a Folder
Hi All, Working on trying to find a solution to the following. We have a dashboard we'd like to use to understand the workload across all of our standard projects. Specifically, we want to know the number of tasks assigned to each person by health status. The Folder "Standard Projects" includes multiple sheets, and will…
-
general questions about enhancements
While researching various questions I have had, I see a common theme about submitting an enhancement request to Smartsheet and people commenting to add 1 to the votes. Is there a place where the enhancement requests are listed so I can either a) add 1 to features I would like, or b) know that somebody else has already…
-
Multiple Approvals Per Row
Hello, I am looking for a workflow solution to our document approval process. Currently we have a Confluence page where five individuals attach a picture of their signature. I would like to set up a sheet to manage approvals of several project documents. The approvals function can currently do this, however, when I send…
-
Approval Emails - Style Questions
I'm using a form for staff travel requests. Once submitted an email is sent to their manager for approval as part of the workflow. When the email goes out, there are two things I would like to remove: The Row # Footer with "you are receiving this email included as a collaborator etc." I think that people who aren't…
-
"Iterative" Formulas or Loops
Hello everyone. I am having an issue where I do not see a way to make any of my formulas iterate any specified number of times, let's say similarly to a "for" loop in a programming language. I am curious if there is a solution I am overlooking or if this is not currently doable with Smartsheet. Please see my example below,…
-
Improving Formula Descriptions
I feel like it could be better shown, for a variety of examples, how formulas can be used. For example, this image doesn't really tell you what the answer to the example is. The example only shows that those data types can be used but doesn't help you understand what it does. Minor gripe I suppose. Also sometimes I wonder…
-
Who could use a PARSE function?
So I have been trying to think of how to best word it, and trying to help someone else with a solution led me down the rabbit hole I needed. How about a PARSE function. =PARSE(range, selection number, delimiter) Use case would be plentiful, but a couple of examples would be... A. You want to search a range for the second…
-
Graph colors change
Ok whats up with the graph colors?? I set the colors to the legend to what I want, BUT if I play around with changing anything from "Switch rows/columns" to any other item the colors change. Very frustrating indeed!!! Are there plans to allow colors to remain as set?? Thanks, David
-
Best chart to show progress against a target
Hi - I'm looking for a dashboard chart widget that shows progress against a target. For example, a target line on a column chart or a target line on a donut semicircle chart. Or a thermometer type column chart where the height of the column represent the target, and the actual is overlaid on top.