-
Up/Down Arrow Colours
Hi, I wondered if there was a way to swap the up and down arrow colours? e.g. I’m applying the arrows to a spend profile and green should represent a down trend. Thanks, Del
-
Searchable form !
I want to have a search option in my dashboard; where if i put a name it pulls all the information from the sheet and shows in a simple manner. Like in hospital they type in the name and all the information comes up. is it possible in smartsheet? and if so can anyone help me? Thanks in advance!
-
Charts - Value over Time
I am trying to create a chart which displays a contingency fund remaining balance over time. Here is what I was able to produce: This looks great, but the x-axis(time) is not to scale. I am pulling from a sheet that contains all instances of contingency fund draws, but they will not occur at a regular interval. Is there…
-
Dashboard automatic updates
Hello, I am looking for a way to send a weekly message to a group of shared users to view the team's portfolio dashboard. Currently I have a scheduled report that is sent weekly, I want to do the same with the dashboard. Thanks Michelle
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Dynamic Widget URLS
Hello All! I've seen similar conversations posted in the community before, but figured it might help with a focused control center group. We heavily use dashboards as image widgets in dashboards to create buttons for our team to navigate. Often these image widgets have a URL shortcut when clicked on, which with SCC created…
-
Auto-size sections on a Dashboard
Is there a way to have a field auto-size on a dashboard? I have a report that gives me what is due in the next 90 day. This can change from 10 lines to 50 lines and each time I have to manually expand the field. It would be great if the field in the Dashboard could change based on the data in the field.
-
Filter for Current User - View on Dashboard not working as planned
Hello Smartsheet people, I have a report that is pulling in all open tickets from a single source sheet, and I want the report displayed on a dashboard. I want this specific report to only show the tickets assigned to the current viewer of the dashboard. The 'has current user' filter is on, and the column type is a contact…
-
Excel Sheets as the base content for Dashboards
Hi- I have team members that are very resistant to anything new. They want to continue to use Excel for their spreadsheets and wonder if the Dashboard and other sheets that folks use in Smartsheets can actively link to their Excel sheets instead of actually having a SmartSheet. I know that Tableau does this - it links to…
-
Dashboard refresh
My sheet gets data from a form and update requests, it rarely needs to be opened directly. I have reports for open items and completed items. I have summary fields in the sheet that count and calculate late items. The Dashboard has metric widgets that look at the summary fields and two report widgets. The dashboard doesn't…