-
Sorting by Grouped Status with a custom order
I'm working on a report that has the usual project status "On track, Paused, On hold, In Queue, Delayed Start" etc… I currently have a list of the project name as a line item, then grouped by applicable status. That said, when "sorting", it doesn't give me the option to see which goes at the top or at the bottom, and…
-
What is wrong with this formula?
I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize…
-
Mass Uploads and multi-sheet interaction
Hey all. This is likely a stupid question that has been answered before. None of the searches I have done have had quite the answer I was looking for. I am working my way through the core app learning path, but I haven't found what I am looking for. There are what feel like hints of it, but nothing that has clicked for me.…
-
Merged: Allow Primary Column to be moved in Reports while using Grouping
This discussion has been merged.
-
Report Automations Remove Link to Sheets
Hi, I have an issue and I hope there is a workaround. I have several reports created for different groups of people to view items specific to their needs. Obviously the report is derived from a master sheet. When I send a notification, I send attachments and only attachments. It confuses people when they see the link to…
-
Portfolio Metrics and Dashboards
Hey all! I just presented the new dashboard solution to the leadership team when I noticed the dashboards aren't picking up anything from the meta data sheet (which in combination with our intake sheet) creates my weekly status report template. Any reason you guys can think of that would make all of my formulas freak out…
-
Looking to Format the report
I am trying to display only one cell with a KPI number from the report, but I am unable to change its format. Any idea how to change format of Report?
-
Dashboard Report view not showing correct Primary Column values
Have many reports pulling from a master sheet which are functioning correctly. But when this report is viewable on a Dashboard, the preview window is not showing the Primary Column values...? In fact, the dashboard report preview is showing a duplicate of a different column values in place of the correct Primary Column…
-
Editable Sheet Summary Report
It would be a good addition to Smartsheet to be able to edit data in Sheet Summary reports, just like we can edit regular Row Reports. I don't understand why the 'two-way' data entry functionality between Sheets and Reports does not apply to Sheet Summary fields.
-
Access to Event Reporting API other then Enterprise plan
Hi, As Event Reporting API(https://api.smartsheet.com/2.0/events?since=2022-01-10T00:00:00Z) is available via Enterprise plan only, Is there any way we can access this API with free trial or Developer account. We require the access of this API for development purpose only. So Please let us know if there is another way to…