-
Create a new row when a cell is updated in a report
I have a Report that pulls from a source sheet. When the data in the Report is updated, I would like it to create a new copy of the row in the source sheet rather than updating the existing one. Currently, since the Report is directly linked to the source sheet, any changes made in the Report overwrite the cells in the…
-
Send Daily Report only when data changes on underlying sheet
How do we send a report only when there are sheet changes. At the moment report is set to a filter where modified field is today. But if nothing is changed a blank report is sent. How do we program so the report is only sent if there is data?
-
Copy-Paste
Please add the functionality to copy and paste rows (from reports, sheets, or anywhere in Smartsheet) with their respective formatting, formulas, and validations, just like in Excel. Right now, Smartsheet only pastes the raw values, which forces us to export to Excel to preserve formats and then re-import. Having full…
-
Labels are not showed for series
Trying to add series labels to the bar chart and it shows only 0 or dash. I tried to use the smallest font as bars are narrow, but still didn't help
-
Status Log Date Push to Dashboard
In a previous, recent question I asked about pushing a text to a dashboard. All the suggested solutions worked. The same scheme did not work for finding the latest date. Seems the code suggested only works for text.
-
Graphs our of Report Data
In order to make it super easy to build graphs, they should also be allowed to source its data from Reports. Reports provide flexibility, filters and will normally accompany graphical data for some Dashboard audiences. Whatever data gets through the Report, it will show in the graph.
-
How Can I Resolve #INVALID Errors in Automated Capacity/Utilization Report?
Hi Smartsheet Community, I’m running into #INVALID errors in a resource management report and can’t seem to track down the root cause. I’ve attached two visuals for context: A screenshot of the report showing which team members are affected (#INVALID appears across all months for some users like Jerritt and Danny). A data…
-
Smartsheet Being Slow
A few counterparts and I have been experiencing Smartsheet loading slow, spooling for excessive amounts of time, or taking a while to refresh. It doesn't matter what type of file we are working with (sheets, dashboards, reports, etc.) we get the same experience. We have tested this on various Wifi's with the same results.…
-
How can show difference in answers on same questions in separate sheets?
I have many categories that each have several statements. Each employee will be sent their one sheet and either agrees or disagrees with each statement. Their manager will complete the exact same sheet about the employee. I want the manager to have a report that displays the category and statement where their employee and…
-
Add document to Portfolio Work Apps
I am trying to add a document into portfolio work apps, however it is saying I do not have permission to do this. I am the owner of the workspace the document is saved in and I am owner of the document. The document is a report and is based off a document I am also Admin on. I can add documents from lots of other…