-
IF/And/Join/Collect
Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "decision" in another column OR a star for priority in another column. I have a sheet used to track RAID entries, and…
-
Merged: Per-widget background colors
This discussion has been merged.
-
Merged: Place column/bar chart value labels within columns/bars
This discussion has been merged.
-
Smartsheet Application Zoom Function
Smartsheets does not support browser zoom levels under 90% and begins to misalign rows, columns, dashboard widgets and more. This is still an issue within the smartsheet application and continues to shift and misalign data and widgets. Specifically building a dash board is very challenging as the alignment tools made to…
-
Why would a formula work on one sheet but be #unparseable on another?
Hello All, I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable. This is…
-
Edit Dashboard within Workapps
Currently, there is no functionality to allow users who have Admin / Edit access to a dashboard to edit that dashboard in Workapp - there is only view or hidden functionality. This means that the user has to be led away from the Workapp to edit the dashboard instead of being able to stay in the Workapp to complete the…
-
Duration column chart for a dashboard
Hey, I am trying to build a chart that shows me the duration of the tasks. I would like this to be a bar chart, so i can see how long each task took in comparison (these are the same tasks in different projects that take people different amount of time). I am unable to use a report that shows the primary column and the…
-
List of reports and sheets used in dashboards and sheets in reports
Is there a way to generate a list of sheets and reports that are used in a dashboard? If not a report, is there somewhere: In the sheet that will show it's used in a report or dashboard In the report that will show it's used in a dashboard or that it uses a sheet In the dashboard that will show it uses a sheet or report
-
Improve dashboard widgets
A major value proposition of Smartsheet is that it can replace Excel. It's then a disappointment to find that the Smartsheet dashboard offers only good but very simple charts. A broader range of charts plus a pivot table and chart option would be very useful. (Noting that the separate Pivot Chart product offered by…
-
Reverting a dashboard?
Hello Smartsheet Community - We have some of our engagement managers who currently make a copy of an original dashboard, modify some items and then share that externally with customers. If someone accidentally overwrites the dashboard, is there a way to revert to the original one that was created when the workspace was…
