-
Automating updates from shared Excel doc to a Smartsheet doc
Is there a way to automate updates from a shared Excel file to a Smartsheet doc? I am currently manually entering data from an Excel file into a Smartsheet to update the information on a Sight. It would be great if the data was automatically updated in the Smartsheet when the shared Excel file is updated. Is that possible?…
-
Graph scale question
Hello Smartsheet community!, I have a question. I built a dashboard with some graphs. Is there a way to change the scale percentage from 120% to 100%? See attached print screens. Thank you in advance for your help!
-
Sights separator lines
Hi All! Could someone tell me how to add kind of separator line like this one? It is sight from smartsheet's template. It is fully interactive, so if I want make it wider, it is enough to drag the corner of this field. I tried to add a picture of a line from an icon, but it does not expand its width.
-
Report on "Current User" on a Sight
When we show a report that is built with the new "Current User" contact functionality, that works great! When we show that report on a Sight, it doesn't dynamically follow whoever is viewing that Sight. The report only shows the tasks assigned to the author of the Sight. That doesn't seem right to me. Does anyone else have…
-
Report assigning random background color
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK
-
IFRAME - load with Fullscreen option
I'm embedding several reports / dashboards into a sharepoint instance and I would like to have them load in full screen by default. I am referring to the Normal View Vs the Full Screen View that can be achived by clicking the appropriate icon on the bottom left of the embedded frame. Please help! Thanks
-
Add up all PAST DUE Items
I would like to add up all the action items on my Action Item log that are Past Due so I can show this on my project dashboard. How do I construct the COUNTIF statement to achieve this? Thank you from the newbie!
-
COUNTIF or COUNTIFS
I think I have formulated myself into a corner. What I am attempting to do is create a total number of all open projects based on the multiple status options in 5 separate columns. So, if the data in columns Stats1:Stats5 match X or Y or X, return that total count. I am able to do this for One…
-
Dashboard reports
Does anybody know how to autosize reports is dashboards, for example if I have 4 rows to show all 4 rows without having to resize the dashboard or if I have 10 rows to show all 10 rows?
-
Dashboards (sights)
Hi All, I'm wondering if anyone can help me out. My current client has one program where each staff (4 in total) each individually have their own projects. I created a sheet for them to use that has these columns: Task Name. Start. Finish. % Complete. Status. Assigned To. Done. Risks. Risks & Issues. The staff go into…
