-
Can you automate hide/unhide column?
Is there a way to automate hiding and unhiding columns based on data in a previous column? Even through a custom integration?
-
INDEX formula that ignores specific values
I want to index a column in my sheet to bring in values from another sheet. In that formula I would like it to ignore specific values (??, NA). Is there a way to incorporate that into my formula so that I only bring in the date values and nothing else?
-
Calculate Week number from multiple choice dates column
Hi, We are running a Wellness challenge for a charity. Participants log the days and duration when they performed the activity. We allow selecting multiple dates for the same activity. I try to total Duration for a week. "Duration" mean the number of hours for each of the selected days. First, I need to convert a date into…
-
Automate Flagging at risk task based on approaching due date
Hi Community, I am looking to automate flagging a task if it comes within two weeks of one of its two due dates (each task has a recommendation date and approval date) and its currently not complete (of which there are two opportunities for it to be complete, the recommendation and the approval). The task must have a…
-
Combine COUNTIFS with a date and row criterea
I have two formulas working independantly and now I am trying to combine the critera but I am not sure which formula to use. Working formulas are: =COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, >=DATE(2020, 1, 1), {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, <=DATE(2020, 12, 31))…
-
Check for Duplicates, Compare Dates of Duplicate Rows, Display Date Furthest in the Future
Hello, I have a sheet where I'm in-taking data from grad students signing up for access to lab rooms. They provide us with their begin and end dates. Sometimes they will resubmit the form when their end date changes and they're at the university longer. I've made a helper column called Duplicates that checks a box when…
-
Join Collect w/ CHILDREN
Hi, I am trying to pull task descriptions w/ a Join(Collect) formula but only for Children of phases w/in a project plan. Here's the formula I'm currently using... =JOIN(COLLECT({Project Plan - EOL Kronodoc Range 1}, {Project Plan - EOL Kronodoc Range 2}, @cell < 1, {Project Plan - EOL Kronodoc Range 3}, @cell = [Phase…
-
Status Roll Up to Parent
Hi, I have a column that has the following status distinctions: Remove Not Started In-Process Final Draft Ready for Group Review Group Review Complete Final TechPubs Complete PTP-In Process PTP-Approved I am looking for a formula that would be set for the parent but only show: Not Started In Process Complete How should…
-
Sum Collect Index Match with a calculation...
I have a list of items and costs associated with the item. I would like to build a formula without the use of a helper column to calculate the total Value of items based on the quantity of items. The list of items is about 300 lines and the number of "people" will be a fluctuating quantity... I would rather not create…
-
Looking to return a value given a specific row and column
I would like update a goal target automatically based on today's date from a matrix. Through "=Today" , I have established the current year and current month. From there I want to populate the yellow cell in the "Current Goal" column for either "Annual" or "Cumulative". This cell will then be cross-linked to a metrics…
