-
Object/Row Linking & Data Display
Purpose: Allow users to quickly view multiple data points from other cross-sheet rows without having to clutter up sheets and create data duplication by using cell links/lookups. Idea: New column type where you can link to another specific row either inter or intra sheet. Think of the row like an "Object" data type or…
-
Banded Rows for Reports
It would be nice if reports created banded rows automatically instead of having to create complex formulas in the source sheet to band rows that flow through to reports. Most of our reports come from one master sheet. If I create banded rows based on one set of criteria, it works great for that specific report. However,…
-
Folders for Calendar App
It would be great to have the ability to place calendars built in Calendar app into folders. RIght now, it is a long list and not very organized. Filters are a good step, but folders would be a leap! Additionally, it would be cool to then grant permissions based on the folder (if needed).
-
Resource Management Capacity View - Exclude Placeholders from Total Capacity
In Resource Management, the new Capacity view shows "Total capacity" and "Scheduled" hours. The scheduled field correctly shows the number of hours assigned to projects. However, the total capacity field includes the total hours of real staff PLUS placeholders. Because we use placeholders in projects to indicate needs that…
-
Calendar App Year header
I would like to have the ability to have year column headers in the calendar app to show high level milestones maps, specifically for dashboards and exec audiences who do not need all the details of a quarterly map (the highest grouping we have now).
-
Return column ids when creating a sheet from a template via the API
Right now, the columns array is only returned if you define columns as part of the request. If you instead use fromId to make a sheet from a template, no columns are returned, requiring a separate GET and effectively doubling the amount of calls needed to create a sheet. The column array should be returned in all cases.
-
Additional RAG statuses and customization
It would be helpful to have no limit to RAG statuses and colours that can be attributed. This allows for greater customization and would act as a visual aid. A prime example is for N/A being able to have a grey status, it would be applicable rather than having to conditionally format a column for Greyed N/A which seems to…
-
Update formula wizard when used in sheet summary
This is because the wizard only offers 'Reference another sheet' when this is slightly illogical as you are in sheet summary ie to summarise the sheet you are in. You then cant click on the column header to add the range to the formula when using sheet summary without an error. The way to add the range is to scroll down…
-
Highlight all cells containing a formula
We are cleaning up existing sheets and need to see where formulas have been overwritten. It would be great to have a permanent indicator that a cell contains a formula so our users don't overwrite them.
-
API endpoint for summary information reports
Currently when using the Smartsheet connector for Power BI, is not possible to grab sheet summary information reports, only reports based on sheet row line information. It would be very good to be able to gather information from summary based reports on Power BI.