-
URL instead of Display Text for SCC Project Dashboard?
When a project is provisioned in SCC it generates a dashboard link using whatever naming convention is setup in SCC. It doesnt appear to have any options in SCC to make it appear as a url instead? I also am checking the column properties or formulas for a way to make this a URL? The problem is that once a Dashboard Link is…
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!
-
Count instances in a sheet and plot them against year entered
Hello! Each row in my sheet is a research case. I would like to count each row and plot that number against the year that the case was created. I have a column with the year. How could I do this? I have attached an example of my spreadsheet. In this example I would want a bar graph that says 3 cases for 2020, 6 cases for…
-
Line chart with multiple date-numbers traces
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I…
-
Date column formula to start on a specific date and continue on after that.
Hello, So I have a helper sheet that tracks total number of entries for each month in each year. Right now I have a formula set up that checks the date above, and depending on if the current month is past that month, it will automatically fill in a new line with the current month (Due to date formatting, I have it set that…
-
Dashboard, column cut
Dear all I have created this Dashboard from a report and on the first column (see picture) value/text is not shown completely - actually it should say LAUFEN. This BRAND column is not the primary column and the Align cell function is also not the reason why it's cut. In the report, the column is shown as it should be. I…
-
Hide Dynamic View name on Dashboard?
Is there a way to hide the dynamic view name, filter, show/hide formatting, wrap test buttons when you embed the view on a dashboard? Or change the format?
-
Transfer data from one sheet to another
I know SS has the "move to another sheet" or "copy to another sheet" but sadly it does not look like you can do that and have "cell links" from the blank form that you are going to copy data to , to do other items. Does anyone do any copy / pasting that is advanced and would have some suggestions? Here is what I am doing…
-
How to capture time elements from a form and display on a dashboard.
Good morning Experts, I have a particular set of data that is tracking productivity with a time element reported as (hour):(minutes) AM or PM I am gathering the data in a form using text/number. Once in the sheet/grid I cannot figure out If I can or how to auto populate the results for a single time element in my sheet…
-
Mass Edit in single dashboard
Hi, Is it possible to do a mass edit in the dashboard. I would like to delete a large group of individual objects, but so far, I can only do them one at a time. Is there a way to "ctrl shift" to select multiple objects for deletion? Thanks! John
