-
Dashboard Labling "Series"
Im trying to get the series labeled so that the colors are Associated with a title such as buildings as seen is second picture re.
-
Allow simple formulas to be add to cells in Reports
I can enter a simple formula in a text cell in a sheet but not the same cell in a report. I have a "Shipping Report" that our shipper uses when the ship out an order. It pulls the client's name, address, due date, tracking number, and shipping cost cells for a sheet. The shipping person can enter the tracking number, and…
-
Is anyone else struggling with duplicate assignments (i.e. Assigned To field)?
Hello! We recently moved a manual task assignment process to Smartsheet. The issue we're experiencing now is duplicate assignments. 10-12 team members are accessing the sheet at any given time. Changes are happening all the time. And while they are refreshing and saving consistently, team members are stepping on each…
-
Solution to analyze multiselect dropdown data and visualize in a reporting dashboard
Hello! I'm somewhat new to creating reporting dashboards in Smartsheet and I'm running into issues since one of the key metrics my sheet has is a multiselect dropdown. I'm aware that you cannot group by a column that has a multiselect dropdown, but what would be a workaround for that so I can visualize that data in a…
-
Kanban or something else?
Hi all. I'm teaching myself how to use SmartSheet in way that works for me. I have a weekly check in with my boss and her boss. Right now I'm just using a grid but I really want to try to use a Kanban. What I cant figure out, and maybe I'm overthinking it, is how can i have it so that they can see the progress I have made…
-
Form fields to include Comments
It would be really great if, in the manage forms section, form builders are able to insert a comments field that would populate as a comment on the row once the form is submitted. I have searched many product ideas and did not see this, but I did find older conversations in the community stating that it would be desirable.…
-
Target range in graphs
I would like to be able to have a highlighted/shaded section on a graph indicating the target range desired for the data being displayed in the graph. For example, The graph is depicting the average number of patient's seen per therapist per shift… the target range is 6-8…. is it possible to have a shaded line parallel to…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…