-
Troubleshooting Sheet Summary "INVALID DATA TYPE"
Hoping that the community can explain this issue I cannot solve (nor can AI). Today we added a Y2026 Savings column to our sheet. Column formulas were all updated as well to look for values with "effective dates" in their corresponding years. Sheet Summary (for Dashboard) formulas broke returning "INVALID DATA TYPE". Tried…
-
Report Help!
Hello, I need to do a yearly side-by-side comparison for providers and their privileges. I thought if I rolled up two yearly metric sheets (one for 2025 and one for 2026) into a report this would do the trick; however, the privileges carry over from each sheet instead of merging and now I can't show them side by side. Any…
-
Ich habe eine Business Lizenz und möchte Berichte für Mitarbeiter freigeben.
Hallo. Ich bin noch nicht lange hier bei Smartsheet und habe einige Probleme zu verstehen, wie ich Mitarbeiter für von mir erstellte Bereiche oder Berichte zum Bearbeiten oder Betrachten freigeben kann, ohne kosten zu produzieren. Ich habe diverse Berichte für Kollegen als "Bearbeiter - kann nicht freigeben" freigegeben.…
-
Get hierarchy/parent of sheets
Hi, I came across a blog mentioning that the Sheets folder feature has been deprecated. As SmartSheet users, we now need to migrate our sheet files and folders into workspaces. Additionally, when calling the API to list sheets, it returns all sheets within the account or profile. So, until it will be migrated to a…
-
Sharing Report but Not the Source Sheet
I would like to share a report, but not the source sheet. The source sheet has personnel information that I do not want to share with our customer, but I made a report with the information I am comfortable with sharing. However, when I share the report, it is blank because the customer doesn't have access to the source…
-
Merged: A report is not available to be a data source for a Metric Widget
This discussion has been merged.
-
Sheet Access report
Hello. Me and my team are doing an audit of users who have access to edit items in our account and one of the reports we're using is the Sheet Access report under the User Management section of the Admin Center. However, we're running into some weird things. When we dig into the Sheet Access report, we sometimes notice…
-
Maintain Column Freeze When Saving New Report
Currently, if a report has frozen columns and is Saved As New, the frozen columns do not transfer over to the new report. This creates an unnecessary additional step in maintaining the new report(s). It would be helpful if the frozen columns carried over to the new report when you Save As New.
-
Add a "Today" button in Calendar view
I would love to see an option to be able to quickly navigate to the current date in the calendar view. Every other platform with a calendar I've used (Outlook, iOS, Airtable, etc.) has a "Today" button that will immediately navigate you to the current date. I already find that Smartsheet calendar view does not always open…
-
Stack multiple saved filters
It would be helpful to be able to "stack" multiple saved filters, so that a user could apply multiple, orthogonal criteria at once without having to create a cross product of defined filters. For example, if records can be either "current" or "past" and either "material" or "immaterial," a user might want to search for…