-
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…
-
Can I populate multiple lines in a report from one form
I am trying to automate our joint health and safety checklist. I have created my data sheet with 88 columns and created my form. Each question has a drop down with yes, no or N/A. When no is selected a comment box comes up to insert the issue. What I want to do in my report is create one row for each issue that arises…
-
Project Planning: Percentage Complete from Dates
Hello I'm currently using Smartsheet for project planning. I want a forecasted percentage complete on progress to date from baseline start to baseline finish. Can anyone help please? Thanks in advance! :)
