-
A function that can subtract multiple values from another cell with multiple values.
In a sheet, there are the following: The A field is a multi-select drop list column type. For example, the A@row cell has the values: 'Apple Lime Orange Pear' The B field is a multi-select drop list column type. For example, the B@row cell has the values: 'Apple Carrot' The C field is a multi-select drop list column type…
-
Justify text
in legal we always use justified text for documentation. When we try to use generate document builder - there is no way to justify text into a pdf.
-
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…