-
Report Builder Automations
Hello Smartsheet Community, I'm building a report and I'm wondering if I click into an entire folder collection for my source sheet, will the report auto-include new grids that get added to those folders or will I have to manually add them as they get created?
-
Email automations in report not working
Hi. I need help with setting up a report to send monthly to specific email addresses every month. I saw others recommendations on automating the "Send as Attachment" in the report, which I tried and it is not sending the reports. Here's the steps I tried: I created a report "Gas Receipts Monthly Report" which will send a…
-
Company logo while using Control Centre
I've previously uploaded my company logo so that it appears on sheets and reports which are exported. However, reports that have been created within Control Centre have the Smartsheet logo when exported. How can I fix this?
-
PDF reports with totals
Is there any way to show the totals on a report when sent in PDF form? Anyone found a solution or workaround?
-
Line chart with multiple date-numbers traces
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I…
-
Conditional Formatting Not Updating in Reports?
I'm finding that conditional formatting is not consistently updating in reports, and my staff are complaining about it. See for example below, the "Rollinson Downstairs..." task highlighted has no conditional formatting even though the date has passed. If I open the Rollinson sheet, it then updates and updates the report.…
-
Dashboard, column cut
Dear all I have created this Dashboard from a report and on the first column (see picture) value/text is not shown completely - actually it should say LAUFEN. This BRAND column is not the primary column and the Align cell function is also not the reason why it's cut. In the report, the column is shown as it should be. I…
-
Can I count data that is saved in a report?
I have a report that collects data from many sheets and gives me an output and a date. I need to count how many are in that report for a given date. Is there any way to count instances of something occurring in a report rather than a sheet? It seems that this should be a function.
-
Count Netdays if Project Status is "Complete"
Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date", and "Actual End Date" I have a grid with 200+ projects/rows (Project Intake Sheet), and would like the formula to…
-
Is there a way to show a parent task on a row-sheet report?
I am creating a report, pulling from multiple sheets, that shows upcoming tasks in the next 7 days. The problem I am running into is that there is no hierarchy shown on the report. I get a list of tasks, but I do not know what 1) sheet they're from or 2) what phase/parent task they are related too. Is there a way to show…