-
Dynamic View widget for dashboard
There should be a widget for a Dynamic View, allowing a dynamic view to be selected. This could then include options to set a filter for the dynamic view. When creating dashboards for roles, this has then required separate dynamic views to be created for each of the roles. If the dynamic view had its own widget, one…
-
Adding formula to help text in Forms
I am looking for a way to display a cell value for the user while they are completing a form; I want to display the current value of an item in inventory that the system thinks we have so the user can adjust it if it is incorrect. For example column = "Gloves", help text would say "We have 6 gloves in stock" and if there…
-
COUNTIF between date range and 2 criteria
I am trying to cross reference another sheet to count all of the projects assigned to a specific person in between a certain range, but the # of projects assigned and the person assigned to the project are 2 separate criteria. For example, I want to know how many "A" projects that Jane completed in the month of January. I…
-
Report Date Sorting by Number Instead
Hello - I have date format sheet summary fields rollling up to a sheet summary report and when I sort on the date column it sorts things by numeric value instead by date values. The sort selections are Newest to Oldest and Oldest to Newest so the filter knows the column/field formatting involves dates/age. Thoughts? Sorts…
-
Building out Charts Issue getting an Error
Hello, When I am attempting to build out a Dashboard I am getting the following error when selecting the report… "selected data cannot be charted please select a new range." It won't let me select other data or specific parts either from the report. I have also tried grouping it and no luck. Any recommendations would be…
-
More Sort Levels
Please add the ability to use more sort levels when sorting sheets and reports. It's pretty easy to run up against the limit of only being able to sort by 3 columns. In my personal experience there are cases I've hit where we would need to use 5 columns to have a sheet or report sorted in the most logical order. I'm sure…
-
Formula help with adding up total $ in one column and associating it to the right business unit
I am having trouble coming up with the right formula for a sheet. I am referencing a sheet to create a formula in another sheet. In the sheet I am creating the formula in, I am trying to calculate (from the reference sheet) the cost by business unit. Here are the two columns I am trying to create the formula for: I need…
-
Workflow coping to another sheet
Hello, I am creating a workflow that I want to trigger when a field has information entered in, it copies to another sheet. If it is blank it should not copy. What I am trying to do is from a headcount report, indicate when someone has a termination date added, they are copied to a separate sheet I have for year to date…
-
Would like the Report Gantt View to grey out days off
The Gantt view in a report would be much easier to view, and use if the days off were grey. It's like this on the source sheet. All the info I can find is for modifying the gantt in a sheet, not a report. Is this possible?
-
Search/Find Column Titles
Finding one specific column out of hundreds can be a real challenge sometimes especially if you are not the one who built the sheet or if columns have been moved around. Being able to search for column titles using CTRL+F (or really any other way of searching within SS) would be a HUGE time saver.
