-
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.
-
Mindmap / Spider Web views of parent/child and relationship dependencies across worksheets
Hi Has anyone looked at or know of a way to create a more interactive dashboard of a mindmap / spider view of worksheet relationships and parent child dependencies within? I am using smartsheet to manage organisational OKR's and whilst I can create traditional grid/card and even dashboard views the OKR tools I am seeking…
-
Default landing page/portal/sheet for specific groups
I need the ability to have specific groups (project teams) always routed to a specific sheet when they sign in. This would be a place to put specific announcements for that team and a set of links to sheets they need (i.e. a directory). We have a lot of non-technical people that have to access project plan sheets, action…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…