-
Creating a graph from 3 variables
Hello, I would like to create a graph in SS from using three variables: CSP name, Observations (Critical, Major and Minor) and Categories (findings). Please find below example: I did create report from the sheet and tried to create Chart in Dashboard, but it says "Selected data can not be charted, please select a new…
-
How can I preserve grouping in a report in Dynamic View?
Hi. I am linking a report to a Dynamic View. however, I want to be able to preserve the report groupings in Dynamic View. How can I do that? Thanks
-
Build report off activity log data from a Sheet
I know that I can download an activity log from a Sheet, but is there an easy way to build a report off the activity log data? I want to track metrics like # of sheet views, unique users using the sheet, usernames in the sheet, etc
-
How can you share a report without giving access to the sheet?
I have created a time tracking report for all employees utilizing a weekly form each completes. As I don't want employees viewing other's time, I created a report for each employee so they could see their own time collectively and make changes if needed, however it only works for the members of management that have access…
-
What controls the formatting of sheet names in a report?
I want to get them all consistent. I don't care if it's a really weird workaround and not a built-in feature - is there ANY way to edit whatever they are based on? Do they adopt the formatting of a particular cell or something? Thank you.
-
Overallocation flag in sheets
Is there a formula or method to identify if a resource allocation flag is triggered for a given row? i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? I'm trying to figure out if there's a way to summarize all of the rows in our project sheets…
-
Multiple Date Ranges within the Same Row
From what I read this is still not an option with Smartsheet. I would also like to have multiple date ranges within the same row. I would like to be able to look at a project (start to finish) but also like to see Section A, Section B, and Section C date ranges within that project on the same gantt chart row. I currently…
-
Formula to Pull Just Words or $ Amounts into a Report
Not sure if this is possible - If there is a cell that has words and then a dollar amount, is there a formula that can be used to pull only the dollar amount into a report and then on the opposite side be able to pull the first part and not the $ amount? Ex: 11111 - Test Item - $100 The format for the example could…
-
Is there a way around the row limitation on report widgets within a dashboard?
Hello, I have a dashboard which shows a summary of key information from a sheet that outlines purchasing history of our company. It pulls from a report that summarizes information from the main sheet as a widget on the dashboard, and allows viewers to scroll down through the history of purchases line-by-line should they…
-
How to create a dashboard from a client smartsheet project
We are working on a system conversion. The project is in Smartsheet but owned by the new system company. They've not been able to provide the level of reporting my SLT is requesting. How can I create a dashboard from that project without doing any changes or calculations, summaries within their project? They did make me an…