-
New in Smartsheet: Smartsheet Sights & Enhanced Workspace Sharing
Our most exciting product upgrade yet is here! Smartsheet Sights is now live. Sights is a widget-based tool that rolls up information from across Smartsheet and other data sources to help you make better sense of complexity, anticipate project gaps, and curate information. To learn more, visit our blog, contact us,…
-
Percentage Formulas and adding to SIGHTS
Hi, I am trying to use a formula based off of Counts or Sum to get a percentage of work done. Then I need to add that percentage into my SIGHTS Dashboard. I am having trouble finding an operator or formula to help me do this. Does anyone know how to best solve this issue? Thanks!
-
help - with formula/cell linking across multiple sheets automatically, without having to manually ad
Summary: I have loads of sheets in a "project" folder, 1 for each project, which have identical layout (column names etc). Each sheets has a region field, which is either UK, China, Japan, HK or Multi. I then have reports which take the relevant information I need from all sheets in the "report" folder, which is then…
-
Line breaks not carrying forward in Sights
I have cells that each have several short topics that I separate using line breaks (ctrl-enter) to make the text more readable. For example: --------------- topic 1 topic 2 topic 3 --------------- When display these cells in Sights using the Sheet widget, that formatting is lost and the topics all run together. This is the…
-
SIGHTS Plan Options
What are the plan options for Sights? Is it a case by case basis? There does not look to be any standardized planned options.
-
Best way to load a file in sights that can be updated
I want to have pdf files on my site and an easy way to update them. I tried loading them in google drive but when I update the file in drive the link on my sight is still the original pdf. sometimes we update a pdf several times a day, what is the best way to do this?
-
Limitations on design - Can I put a forumula in a cell in a date column
Only a couple of days into the trial and I was looking at creating some KPI's for a Sight. Based on what I'm seeing, the underlying calculation MUST exist on a sheet somewhere to be pulled into a sight. The problem I run into is if on a sheet a column is a date or drop down etc. and I want to use a cell in that column in a…
-
Thank You! Sights Image Feature
Thank you for yesterday's update allowing images to link to sights via Metrics and Sheet Data widgets. My staff and clients will appreciate it. Now it's time for me to build more Sights. I am able to import an image from another BI Dasboard software to a cell and present it on our current and future sights.
-
Display report data rolled Up?
Hi there I’m currently running an exercise where we are asking a group of 30 users 10 sets of questions each. Each set of questions has its own web form so there should be 10 responses from each user (300 separate rows in total). I have this working fine. The users have requested a ‘dashboard’ which would allow them to see…
-
Multiple projects on one sheet
We have several large projects that require their own sheets. However, we also have many small projects that do not justify creating separate sheets. They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that. Does anyone out there use one sheet for multiple small projects? And if…
