I have a dashboard chart widget whose source data is a report on a sheet. There are times when the report accurately returns no data from the sheet that meets the reporting filter criteria. In that case, the dashboard chart widget displays an 'Unable to display chart' error (screenshot below). This error message is…
This discussion has been merged.
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
I created a reported and I then exported that report into Excel and then uploaded that Excel into Smartsheets as it's own sheet. I want to be able to data mesh from the report to the target sheet, but even though it's identical information when I data mesh it wipes out all of the information from my Assigned To column.…
Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. This column would have sensitive information in it that I do not want the other owners of the…
Hello! I am using a report that consolidates data from 40 other sheets for Power BI reporting. The report doesn't refresh the data unless you click the refresh button. Other than using selenium, is there a native Smartsheet feature to refresh on scheduled intervals?
I found an old thread in the community about this, so mayn users are looking for it a long time already. I need to be able to update reports using the API, most importantly I want to add or change the source sheets of a report using the API. In my current case I have multiple reports using the same sources and if a new…
It would be really great if, in the manage forms section, form builders are able to insert a comments field that would populate as a comment on the row once the form is submitted. I have searched many product ideas and did not see this, but I did find older conversations in the community stating that it would be desirable.…
