-
Reminder if Nothing has Changed in a row
Hey, I am trying to add a reminder or notification to people (identified in the row) if they have not updated anything in the row in the last month. Is there a way to do this? If not, I would also be okay if having a notification/reminder go out to people (identified in the row) if a specific column has not been updated in…
-
Help w/ Date formula
I am trying to make a formula that inserts the date when a selection is made in a drop down cell in another sheet. For instance, the user selects "IIMC / INSTRUMENT" in the training drop down. I want the date it was selected to fill into the other sheet. Dropdown. I want the date to go into this cell on a separate sheet.…
-
How to use a form to fill in a sheet with pre-determined "Primary Column" fields?
I need to build a form that will fill out the sheet shown below. The "Workstreams" column is a pre-determined list of Workstreams; I just need my customer to be able to provide the info in the rest of the columns for each of those Workstreams. I am hoping there is a way to do this without having to duplicate the columns…
-
HAS and Children Functions
I have the following column1 formula: =IF(HAS(CHILDREN([Column2]@row), "Text"), 1, 0) which sets the value of column1 to 1 if "Text" is found in any children in Column2 This formula works well for a single nested file of children. However, I have a multi-level nested file (i.e. Parent1, Child1, Parent2, Child2) and it…
-
How do I score out a survey and have it populate in another column?
Hi everyone , I am attempting to create a scoring system for a survey based on this type of scoring below. These are the survey questions and it already built in a sheet. Thanks in advance for the support.
-
Calculating Avg Workdays w/ Conditions
Hello! I'm currently trying to calculate the average amount of workdays it takes for each person to complete a specific request on a metrics sheet from a parent sheet. For example: How long does it take me on average to complete a FOIA request? How long does it take me on average complete a litigation request? Request Type…
-
Using WEEKNUMBER formula between years
I use WEEKNUMBER to calculate the week number of the Start Date. For example, if my first project task is set to start on 05/01/2023, the formula is set to =WEEKNUMBER([Start Date]@row) - 17, which shows 05/01/2023 as week number 1. Subtracting the '17' is how we make week 18 week 1. My issue is, if I make that a column…
-
Calculate the # of months between 2 dates, with 1 date being static
Hi all, I am trying to insert a formula that will calculate the number of months (overlapping years) between two dates; 1) Requested Start Date, which is a data column on my sheet, and 2) 12/1/22 as a static date in every calculation. So far I have been able to create a basic formula that works, however, I had to create…
-
Using INDEX/MATCH to pull a date and CountIF not recognizing as a date
Hi, I'm using INDEX/MATCH to pull a date from one report into another based on the same ID number. If there is no match, an error message populates. =IFERROR(INDEX({Corporate CAPA Closed Effective Date}, MATCH([InfoCard Number]@row, {Corporate CAPA Closed InfoCard Number}, 0)), "CAPA Not Closed") Once the formula is…
-
Excluding data when using COUNTIF
Hi, I have a graph on a dashboard based on the status of a project using the following formula for each status: =COUNTIF({Optimisation List Range 2}, "Unallocated") We do not want to pull through any project that is on hold but want to keep the status as it is on this column so have an additional column with the RAG Status…