-
Sight - sharing via email a PDF version
Is there a way to share the sight the same way we are able to share a regular sheet? sending it via email in PDF format at a certain frequency rate (monthly, weekly etc)? Thank you Luiz
-
Change Google Drive Account
I've been experimenting with Google Drive to share docs on a Sight. I now need to associate a different Google account vs the original I used to test things. I am unclear how to do that. Can someone share how to make that change? Thanks.
-
Pulling text through from other sheets
Hi I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score). The risk and issue Log have a text description (there is a risk that....) and a risk score (5). I understand cell linking but this won't work as the top 5 risk and issues will change on…
-
Nested IF Error - Incorrect Argument
Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar column with ranges based on a Status % column for a Project Tracker. Here is what I have: =IF([Status %]88 = 0, "Empty",…
-
Charts - comparative data colors
I am having an issue with charts and my column colors. I am getting all the same color columns. I asked about this in the webinar last week and received this answer: "Colors are going to denote different comparative values (what's labeled in your legend). If you're not comparing more that one data set, you won't have…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
Dashboard Shortcut Widget Scrolling
Hi. I have a lot of sheets that I want to have shortcuts in a single shortcut widget but have limited space in our dashboard layout. Is there any way to have it show a scrollbar? Thanks!
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Dashboard widgets - Charts
I just want to tell everyone that with the additions of the chart widget, I am really loving our dashboards. I do wish the legends were editable and the selections didn't have to be side by side. I got around this by creating a second sheet and linking cells to the needed data. I could then create the labels I need and use…
-
Charts - Dashboard Widget
I'm trying to create a pie chart using data from parent rows. I want to use first column as the labels and the corresponding (right) column with the numbers as the data. When trying to do so, I get the following message: "Please select a cell or range of cells that are next to each other. If your rows are collapsed, please…