-
Report in HTML
Hi, i have a sheet with all manufecturing data including PO, drawings, documents etc. i want to generate a report for a few columns and give it to my client so they could track online what the status for there purchasing. i do not want to share with them the attachments file or comments - only view without smartsheet user
-
Creating a Report that ONLY shows rows with Attachments
Is there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 days, but I can't seem to find a way to get the Report Builder to only show rows with attachments added. I realize I could…
-
Do formulas not transfer over to reports?
Hi everyone, I have a formula in my sheet that is not showing up on my report. It's a simple formula; how many days late something is, and I really need that info displayed in the report. Ideas, tips or tricks? Thanks! Ashley
-
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.