-
Hierarchy Visualizations
Excel has hierarchy visualizations (Create a sunburst chart in Office - Microsoft Support) including the sunburst and treemap options. These type of visuals are very effective at displaying organizational information. Recommending creating these for dashboards in SmartSheets with prioritization to sunburst over treemap.
-
Create your own template for Report and Dashboard
Have the option to 'File-> Save as Template' in a report or dashboard like you can do with a sheet.
-
Including a checkbox column in formula returns "INCORRECT ARGUMENT SET"
Hi all, I am trying to make a formula that Calculates the hours spent on tasks with certain conditions. I have 2 arguments in my formula that are currently causing it to return this output. Here is the formula: =SUMIFS({Custom Engineering Requests: Days To Complete}, {Custom Engineering Requests: Drawing Category},…
-
How to compare form responses with a list of emails?
Hi! I have created a survey/form and emailed it out. One of the survey questions asks participants to enter their email address. How can I compare their responses to the list of emails I sent the form to? I would like to create a report that shows who has responded and who has not based on the email addresses.
-
Comparing the time contractors plan to work VS actual hours on a dashboard
Hello all -- I want a sheet which will be used for contractors to log their planned billable hours, their actual hours, and their planned time away for a given week. The spreadsheet will have multiple weeks in it, and contractors will fill it out for several weeks at a time (the planned hours and planned time away). As…
-
Issue with report not displaying all rows on Dashboard
I created a report based on a date, which itself is the result of a formula based on a number + an Assigned Date. The report displays a count of each row that has a particular date. The issue is that the dashboard will not display the first row with a count (see screenshots). When I re-sort the data to display the newest…
-
Does SmartSheet Allow User tracking similar to Google Analytics?
We would like to track the usage of Dashboards, Forms and sheets if it is possible similar to Google Analytics?
-
We need a search option in the dashboard to pull out rows matching keywords provided by the user.
Example: We used dynamic view to create a web content widget in Dashboard. We are able to use Filter option to bring out status of rows but it would be very helpful if "Search" option is present. Our expectation-- By entering a keyword in the dashboard widget it has to pull the rows of smartsheet table having the…
-
Reduce clicking, allow user to edit all sheet and sheet summary formulas at once
I feel like I'm clicking endlessly... 👆️👆️🖱️Double-click to open the cell formula 👆️👆️🖱️Double-click to highlight the part that I need to edit 👆️👆️🖱️Double-click to open and edit the next cell... My hand hurts. It would be great to have some sort of edit pane that allows me to edit all formulas on a sheet at once. Or…
-
The web content widget doesn't shop up on mobile. It shows a generic icon, will this ever be fixed?
The web content widget doesn't shop up on mobile. It shows a generic icon, will this ever be fixed?
