-
Automating which columns are displayed in a report
Is there any way to automate which columns are displayed in a report based on data entered into a worksheet? I suspect the answer is no but I'd like to confirm. I'm envisioning a scenario where I have a chart on a dashboard that displays financials by month, year, and quarter. It would be great if I could create an update…
-
Capture historical data for KPI dashboard
Having real-time data available for our dashboards and reports has improved our management capabilities. I want to be able to share how we have been doing over time, as well. I want to capture and report KPIs over time. I have a report that can capture the information I need but have been trying to figure out how to…
-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
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:…