-
Automatic WBS Numbering
We have a work around but it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
Auto check all check boxes in a column
Hello! I have a sheet with a check box column where end users select the check box to nominate a speaker which will trigger a separate workflow. The issue with individually selecting is that there can be upwards of 100 speakers on the list. Is there a way to have an option for the end user to click one check box or choose…
-
Merged: A cohesive/real-time ability to work with multiple people within a sheet at the same time.
This discussion has been merged.
-
List distinct values based on a criteria and remove blanks
I am making a metrics sheet that calculates what I need to show from a datasheet. The datasheet has columns for the Type (building type is either MOB or Hospital) and Departments (MOB has 12 departments and Hospital has 24 departments) along with a bunch of other columns that have data. In my formulas {CD - } is…
-
How to use COUNTIFS where there are 3 conditions (columns to be referenced)
I'm trying to create a formula in a metric sheet that is referencing another sheet where data is held. I've been able to set up a COUNTIFS formula that references 2 columns so far, but my issue is that it doesn't seem to let me reference a third column using the "formula builder" as below: I'm trying to use COUNTIFS to…
-
Sort column containing dates in chronological order
· Problem: It is not possible to sort a column containing dates by chronological order · Use Case: list of annual leave for employees working on a project · Ideal Solution: Enable sort by: chronological order for a column containing dates
-
Sheet Filters on Reports
Sheet filters are extremely useful ways to view sheet information, it would useful to have the ability to select a sheet filter when developing a report to avoid having to duplicate the filter setup process.
-
Does anyone else have an issue with the date filter when using DataTable Connections?
I have an issue with DataTable and Sheet Connections where I will setup a connection and put in a date range filter between two dates 1st - 30th June, press save and the table will update with the data from 31st May and 29th June! I go back in and the connections filter has changed to the 31st May and the 29th June! In…
-
Question: How do I update a sheet and have it reflected in all projects?
Hello - I need to add a row to a sheet in our project toolkit. I have added the row to the metadata sheet, but when I created a test project and it fed into the intake sheet and control center just fine, it's just the sheet (our project status tracker) isn't updating with that version in the new toolkit. What am I doing…
