-
Report Sorting on Non-Included Columns
Right now, on reports, you can add a column, sort by it, and then remove the column and the sort remains (at least when I test it, it does). However the Sort menu shows blanks. This can also be a tedious process - adding columns just so you can sort by them and then remove them. The Filter function on a report works on ALL…
-
Default values in Columns
Hello all. We have a Sheet and sometimes users forget to add important fields. We want to add default values to these fields in order to not be empty. The types of columns that need to have default values are: Text/Number, Contact List, Dropdown List. We have tried a way to add default values with workflows on Dropdown…
-
Set up hidden columns like "Filters" do for rows.
Is there a way to hide columns and then save that column-hidden configuration? And recall it late. The same as "Filters" do for rows, except for columns.
-
Merged: Group Columns
This discussion has been merged.
-
Count Rows in Reports
Currently there is no way to capture and report the number of rows in a report (or across multiple reports). It is common in dashboard reporting to create a metric (or card visual) to count the number of specific items in a table by simply allowing an application to count the number of unique or distinct rows. For example,…
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
Using Sheet Summary To Populate Columns - and Have Same Restrictions
I'm using a sheet summary to add some global sheet data (i.e., it's not associated with rows, it's associated at sheet level.) I've got a sheet summary contact list field where I add the project manager - then it populates the top cell in a column. I then use this cell as an email recipient in a workflow. However, it…
-
Collapsable vertical header list to hyperlink to column
In the same way that Dynamic views and WorkApp resources listed on the left can be collapsed or expanded, I would like to see a searchable, sortable, vertical column with scrollbar that lists the headers of all columns in the sheet. Each column header name would hyperlink directly to the column I want. I have 80 columns in…
-
Due in Days and conditional formatting question
I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column…
-
Ability to Customize Displayed Columns on Initial View of Selected Workspace(s)
Currently, after selecting a Workspace from the Browse panel the initial screen displayed has six columns displayed: Select (checkbox; ☑️) Favorite (star; ⭐️) Name Sharing Owner Last Update It would be great to be able to customize these columns with additional data points to aid with navigation and understandability (from…
