-
Alphabetize Filter Options
In one of my sheets, I can create a filter for the field "Project Manager" In the field(s) Show columns that match...if I click the dropdown arrow to give me the options for selection, I do, in fact, see a scrollable list of project managers - out of order - How can I alphabetize this list?
-
Support function on account?
Hello, I have raised a ticket twice for the same issue and have yet to receive any reply a month later. I have taken a screenshot the second ticket raised to capture date and ticket number as nothing was received for the first ticket created. The issue itself isn't a huge problem, I am more concerned that we have no way to…
-
Limiting what customers can and cannot see for projects
We use smartsheets to run our customer projects. The approach we have used to date is to create a workspace for each customer, with the necessary sheets - all from a template. This works really well, as the customers need to review and contribute to several of the sheets that we use, and the workspace sharing feature lets…
-
Date and/or time stamp solution
We use Smartsheet in many wonderful ways but, in my opinion, the lack of a method to easily lock a cell with a date and/or time stamp is an open door for a competitors raid. A few years ago, I left Smartsheet because images could not be exported with line item details and there was no "key" to associate with a file export.…
-
Remove Mouse hover over pop up tool tips on menu bar ribbon
Is there an option to remove the pop-up mouse hover tool tips on the top menu bar ribbon? It is getting in the way of the feature buttons and has become very annoying. Thank you!
-
Legend Totals
On the dashboard when I add a chart I would like the ability to include a total next to the legend item. For example, if I am doing a pie chart, in addition to seeing the total items represented by that color in the pie chart, I would also like to see the total items next to that heading in the legend itself for quick…
-
Dynamic Status
A more refined and slightly more universal solution to the first posting is as follows: =IF([% Complete]18 = 0, "NOT STARTED", IF(AND([% Complete]18 > 0, [% Complete]18 < 1), " IN PROGRESS", IF([% Complete]18 = 1, "COMPLETE", IF([% Complete]18 > 1, "INVALID ENTRY", IF([% Complete]18 < 0, "INVALID ENTRY"))))) This assumes…
-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…