Formulas
Discussion List
- Hi all! I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that…
- I have seen various other questions in the community, but I can't quite get my equation there, I am trying to convert a drop down from a form to a date in the adjacent column. All dropdown items are f…
- Hi, I have several formulas in sheet summary that reference a single person in an assignment column in my sheet. The formulas are repeated multiple times and work just fine, however I seem to have iss…
- I am working on a formula to check all boxes in the rows that match the identifier column if there is a projected date and it is greater than or equal to today. I collect the start and end date and if…
- Hello everyone, I have a question. I am trying to create a formula which is supposed to check a box if a specific word (lets say word1) is in column 1 and there also is a date in column 2 or if there …
- I have a spreadsheet that contains all of the inventory information for a lot of products. These products are broken down into categories. For example, shoes (a parent row) would have the child rows o…
- Since the groups are the only way to categorize users, we use groups as "departments". I'd like a formula to get the name of the group where each user belong to. thanks
- I need to create a formula to count any lines that reference "GEMS Point", that will further filter only for any references within a given month. I have the following two formulas that are working per…
- I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work…
- Hi there, I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked but I need assistance on changing the order of it. Course Date with Parentheses around the date and Couse Name…
