Formulas
Discussion List
- Hi, I am testing the functionality of the Global Update feature in Control Center using the Starter Project data. Since not all my projects will have budget information available and entered in the Re…
- There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the colu…
- Hi, I'm in the need of extracting the Non-duplicate values in a range. I could able to achieve same in the excel (Formula =UNIQUE(A2:A16)). See the attached excel schreenshot. I knew Distinct function…
- Hello - I need help with a formula for a status column based on a date range (start and end columns). Status options for the formula include: Not started, Live, Completed For example, is the item has …
- Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Co…
- I was looking for a simple COUNTIF formula to search the entire column and only count the cells that have a value. It can be any value. Does anyone happen to know of a formula that would work for me?
- I'm trying to pull the notes from a Request sheet into the Review sheet, but I'm only getting results when the search criteria (Contract #) is the only contract in the cell in the Request sheet. Ex 1:…
- So, I have a raw data sheet that shows each time an employee receives a type of correction within the organization. I need to somehow extract both the most recent and highest level they currently have…
- I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index…
- I have a column of values, I'd like to use a Join function to combine all the values into a list, but first i'd like each of these values to be trimmed via the left function. Here is an example of the…
