-
Help to Sort by number and words
currently we have a built in prioritization score based on the data entered on the intake form This will populate either a score of 1-5 OR the word "Tech" When filtering these through the report on our dashboard we want to sort in descending order but want those with the word "Tech" to populate last instead of first I am…
-
Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible. I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet if…
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
How can I get the legend for a pie chart to display ALL series even when their current value is 0?
I've been having this issue while building dashboards for a while. I want to use a pie chart, the data contains 4 series. The values will update via their formulas over time, but right now the value for 3 of the 4 series is 0. For all of the other types of graphs, all series are displayed in the legend regardless of their…
-
Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
-
Removing widgets from dashboard view if access is not already granted
When creating a dashboard some widgets will be hidden for certain users. The outline of that specific widget (report) is then still visible with the message stating it is not accessible. The widget should not be there at all. This results in the dashboard looking incomplete and I do not want questions from the blocked…
-
Integration of interactive maps into Smartsheet.EU
Hello everyone, I hope you are all doing well! We are currently looking for a way to integrate maps into Smartsheet.EU (based on a database of distribution partners managed in Smartsheet). The purpose would be to filter locations (e.g. by postcode) to get a quick overview of possible partners for a given area and to…
-
Average if when date is current year
we want to update the formula to show the average # of problem solving days when the idea is a JDI and the opportunity was submitted in the current year. Current formula - missing component to reflect only submissions from current year. =AVERAGEIF({APD CI Tracker Range 5}, ="JDI", {APD CI Tracker Range 4}) {APD CI Tracker…
-
Charts Plotting 0
I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values from showing on the chart. At this time the only solutions that we can provide would be…
-
SharePoint Permissions and Smartsheet Dashboard permissions
It would be great if there could be a way that a SharePoint permissions groups automatically translates to a Dashboard's sharing permissions list or even a Smartsheet Group outside of using an API (which I haven't even attempted yet). Basically, we want to share a dashboard on a SharePoint. This SharePoint is locked down…