Hi, I am looking to generate a roster, using a grid / report and represent this eloquently in a dashboard that we can link through SharePoint or other mechanism so it stays up to date.... As an example, I am showing the way I currently prepared the grid view: Then, I tried to build a widget report, but it's listing all the…
Hi, I am looking to create 3 metric widgets in my dashboard that reference the cells highlighted in red from the report below... It appears that I can only reference a sheet or sheet summary to create a widget. However, is there any work around to get this to work (i.e. build a sheet that references these cells, etc)?
Hi, Is there any way to apply conditional formatting to the colors in a bar chart? As an example, I would like positive %s to be green and negative %s to be red. In this case they would all be red, but as we update data it will change over time, and I want to apply the logic now.
Hi, I am trying to set up an automatic workflow that will send a notification to users who have tasks assigned to them on a weekly basis (recurring) to get status updates. I have created the following request with a custom message: However, some users are not seeing the customized message, so they are unaware of the task…
Hi, I have a few questions about chart formatting in smartsheet. Chart is referenced below, and my questions are as follows: Is there a way I can reduce the number of dates shown on the horizontal access but still retain the granularity in the data set? Is there a way to change the formatting of the date itself (e.g.…
Hi, I am trying to build some dashboards widgets that sum up the number of tasks in a list. The list includes multiple "parent" type rows, but I only want to count the child fields. I created a 'heirarchy' class, but the problem is I need to sum both the 1s and 2s based the various categories. Also - how do I actually get…
