-
Report not showing data from a sheet
I created a new smartsheet with data. Then I have added this smartsheet to an existing report In the report i can choose columns from my new smartsheet but they are all blank. Please advise?
-
Formula that will update the new Year dates
Looking for a formula that will automatically update my reporting dates to 2021. Start date is the first day of the month, end date is the last day of the month. Quarter dates are based on first day in January, last day in March, ect.
-
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in dropdown
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in multi select dropdown ? Solving for: How many "Devon's Corner" Leads do we have by Location Type - "Bar" or "Brewery".. If any or both of these options are selected, they should be counted as 1 =COUNTIFS({Brand Type 1}, "Devon's Corner",…
-
How does everyone feel about the new report builder?
Wondering what people's thoughts are regarding new report builder, ease of use, etc.
-
Formula help to return differnt conditions
Hi I am after help in developing a formula to look for certain conditions. I require the highlighted cell in blue perimeter to record certain condition if a condition is true from the 5 cells below. If all cells return Completed then return "Completed" If all cells return Not Started, then Return "Not Started" If all cells…
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
New Report Publish Current User Not Working
I Published a (new style) report using Access Control-Only available to Users, however, it continues to show the view the publisher sees. The report is Filtered to Current User on a contact column. This help file seems to indicate that it should show the Current User view:…
-
Some feedback on the report filter changes that others may want to add on to
Logging in today I saw that the report filters had undergone some changes. At first glance, it looks great. Upon actual use though, a certain issue arose quickly. This is mostly due to the formatting of the filter selection window drop down. Column headers are cut short with nothing to show the full name even when the…
-
New Reports - Can free users filter?
I noticed the new reports layout was launched. I'm excited about it but one thing I was assuming it would allow was the ability for non-licensed users to apply their own filters. Am I wrong? I don't understand why regular users can apply their own filters to sheets and dynamic view but not to reports? It is a huge limiting…
-
Why did new report builder not translate logic from old report builder?
A previous report logic is not working in new report builder. I have, so far, been able to duplicate the logic of the old report filtering using the new report builder