-
Looking to summarize data from multiple rows to multiple columns so I can generate a document.
I have taken over employee attendance tracking at work. I create new rows in a sheet that supervisors go in and confirm time. The columns for that sheet are in the first photo. Each occurrence is captured in a new row. The issue is, I need to be able to generate a document and cannot do that for more than one row. So I am…
-
Formula to indicate which quarter the Project's end date is in ...
… I had a formula that was working before July 1, but now "Incorrect Argument Set". :( The purpose of this formula is to indicate where the project's end date is in the Past Quarter (one quarter behind the current quarter), the Current Quarter (the end date occurs within the current quarter we're in), and the Next Quarter…
-
Trying to list distinct values from another sheet with a certain status
I am trying to list out distinct values from a separate sheet that are not marked as canceled. I am using this formula, and I only see a blank cell, even though the source sheet is populated. =IFERROR(INDEX(DISTINCT(COLLECT({Drug Name}, {Project Status}, @cell <> "Canceled")), [Primary Column]@row ), "")
-
I need to split a table
The rows I have: Serial, Issue 1, Issue 2, Issue 3 1 , A, B, C The result table I want: Serial, Issue, open… 1, A, yes 1, B, yes 1, C, yes How do I split this table?
-
Can you write a formula to Match the row id?
I am trying to use the Row ID numbers for a formula but can't figure out if that is possible. Do I need a helper column?
-
Count Date Once, Ignore Duplicates
I am pulling data from a time report. I want to identify how many days (through the Date column), someone (individual sheet) was in the Office (one of the allocations in the Location column drop-down list). Each day may have several rows related to one date, as there is a variety of allocations under the Department and…
-
Moved: Dynamic View Document Download not working in Chrome
This discussion has been moved.
-
Can you change a status in a dependency row once their predecessor is complete?
I have a project gnatt schedule that has a status column dropdown of "Not Started", "In Progress" "Complete" and "On Hold". When the status changes to "Complete" can the dependency row be changed to "In Progress"? Once the Econolite Collection changes to "Complete" I want the status of the Rack Elevation Facility Visio…
-
Auto check box when conditions are met between two sheets
Hello Community, I am rebuilding my inventory and compliance workspace. I have been using Datamesh to automate a lot of processes that took me a lot of manual time to do. However, I cannot figure out one thing that would make my processes easier. I have a form where my users submit product compliance monthly. They provide…
-
Pattern match text string against multi-select dropdown
I have a column which has unstructured text - for example, a message from someone asking help in their own words. I would like to match a row from another table based on one or more keywords. In this table, there column with a drop-down list, if one or more of the items in the drop down list are present in the search text,…