-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
-
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.
-
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…
-
Why won't my dashboard update automatically?
I have a dashboard that references one sheet. The dashboard will not update unless I make a change on the sheet it references. I've tried refreshing the dashboard several times, checked on my phone smartsheet app, different computers, its not updating anywhere. Once I make even a minor change on the sheet it references and…