-
Selecting one row across multiple sheets for reporting
Is there a way to select/display just one row's information from multiple sheets into one report? Meaning if I am using the same template across 25 sheets and want just the one parent row from each of these sheets to show on the report, is there a way to do this? Each sheet has tasks associated with it and the parent row…
-
Summaries in Reports
Hi, This has probably been asked numerous times but I just can't find the answer but I can't believe it isn't possible. I am making a simple equipment inventory with servicing data within it. The services are carried out on a 1,2 or 3 year rolling cycle, so I want to be able to print off a report at the start of each year…
-
Capturing a Total Count to display in a Dashboard
I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "Yes"),in a separate SmartSheet, and then creating a Metric Widget within the Dashboard to…
-
Is there a way to email someone from a report?
Hi all, I have a published report and my leadership would like there to be a way to 'click on the contact' in the report to be able to send them an email. I'm pretty sure this can't be done in Smartsheet but I thought I'd consult the "brain trust" here ... We were thinking of trying to create a hyperlink with an email in…
-
How do I avoid an export to Excel combining multiple cell values into one?
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values. When I export the sheet data to Excel, those multiple values get combined into a single value. For example: A cell in the sheet contains three category values: Content labeling,…
-
Row report with spreadsheet summary columns - Relatório de linha com colunas do resumo da planilha
In the row report create the possibility to include columns with information that are in the summary of the spreadsheet. For example in the summary of the spreadsheet we have the fields start date and responsible. Allow the creation of a report of project lines with the tasks of each project, project start date and…
-
Sheet Summary Report Grand total row ?
I am bringing in 2 separate sheets into a sheet summary report using a custom column called "Total Revenue" which is a sum of each individual sheet's revenue rows The sheet summary report is showing correctly both rows for each sheet and the corresponding totals for each sheet. e.g. Miami $138,875 Tampa $264 My question is…
-
Workflow that Generates a report for signing
Hi, We have built a form that creates a record for a client hand over inspections but it needs signing. We currently have adobe fill in and sign. What is the best way to get the form into the ipad app to have the client sign? Can i create a workflow that automatically emails a pdf report for the record to the users email…
-
How many rows can a report collect?
I created a report that pulls data from 4 different sheets. It has multiple items on a single date, so calendar view is the only view I am interested in using. The data on the sheets goes up to May, but in the report, it stops showing at April 15. When I look at the report in Grid mode, it is exactly 500 rows. How can I…
-
Scrolling a dashboard inside an iFrame on iPhone - not working
Hi, I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freeze on the report dashboard, and it does, for a couple rows of scrolling. But then I…