-
Track changes in a data element over time
A customer of mine would like to be able to see what rows in a project plan have changed their task status over a given period - probably a week. A scenario would be in preparation for a weekly team update meeting, the customer would like to be able to see a summary of what has changed from 'Red' to 'Yellow' or 'Green' and…
-
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…
-
Automatic report creation with custom template
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API or integration with any other platform that would make this possible? Any help is much…
-
Datamesh - way to transfer only parent row to sheet?
Hi all, I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet. The Pivot Table is set up where each row I need copied into the existing spreadsheet has a Parent Row (a number) and a Child…
-
Nested if for FLAG column
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the date is in the past and (3)if another referenced value [Shipping Status] does not have…
