-
Status Report / Table
Hello, I am stuck with piecing together what I thought would be a simple visualisation. I'm trying to build a report to go into a dashboard that shows the status of various projects in a table like this: I need the columns across the top to run left to right in a specific order and beneath that I want my Project Names to…
-
DynamicView and reports with groups
Anyone have ideas about how to use DynamicView to show column summaries as we now can in a report?
-
Reference Sheet CountIfs Formula
Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula is: =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", Status:Status, "Open", Project:Project, "Data Analytics &…
-
COUNTIFS
I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
-
No Title for Second Column Selected in Chart on Dashboard
Hi Everyone, Thanks for your help. I've got a few spreadsheets with data collected, and I'm trying to make a chart on a dashboard. I'm very comfortable in Excel, but for some reason I can't get the title for the second column to read in my charts. I have flipped back and forth between "Switch Rows/Columns" and that doesn't…
-
Adding a system generated column to a row report?
Can you actually add a system generated column to a row report? I have a system generated column to track when new rows are added to a sheet but I want to post that to a dashboard as part of a row report and it won't let me choose that column. I don't see any documentation that says it is not available to do this but I…
-
Printing Reports
I want to print out reports from the smartsheet and print out like it is shown from when you get an email copy of submitted forms (if that makes sense). Currently I am only able to select an entire row and it prints it out very small and stretched to 2 pages. Can I have it wrap the text/columns? I need it easily visible…
-
Reports, Group and Summary options
I realize that the primary column must be viewable (unhidden) in order to see the Group and Summary titles when using those functions in a report. The issue I am running into is the name of the Group and/or Summary is a bit long. In order for it to fully display, the column must be very wide. Any ideas on how I can "merge"…
-
add a source sheet or column to a report?
Is it possible to use bridge to add source sheets to a report? Also, it is possible to add columns to reports with bridge?
-
Using Smartsheet Forms as multi lingual survey tool
Hi, I am using the forms function to collect data from people in many different countries. The information we are collecting is in binary, single select, and multi select formats. This information is being summarized in a separate sheet, where we are counting the instances of each response from the binary, single, and…
