-
I need to create a row for multiple names recorded in a form and duplicate the other cells
I use a form for group training, where there are multiple fields to add names of employees, but all other fields have the same answer for everyone. How can I create a row for each name when a form is submitted and have every other column (that is not a name) just duplicate the original's value? Getting this result can be…
-
Modify a COUNT(DISTINCT(COLLECT to a COUNTIF(DISTINCT(COLLECT
So I have this formula which works fine. =COUNT(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =(Date@row)))) I want to change it to a COUNTIF but I can't get it to work. =COUNTIF(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =Date@row)),…
-
Formula based on last modified date that skips weekends
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
-
VLookup Pulling wrong information
I have a Card Name in the Column in the original sheet. I'm trying to bring the approval data and time back to the cell from "Track Approval" sheet. I'm using the following formula. =VLOOKUP([Card Name]@row, {Track Approval Range 1}, 1, true) What am I doing wrong?
-
#No Match error when using VLOOKUP
I am getting a #NO MATCH error in my VLOOKUP formula which is using a date to return a Period value from an external table. The table example is below. The formula is below. The date I am referencing in the End Date @row is definetely in the external table above. Does anyone have any ideas why this is not working?
-
Date Formula: Calculate the number of days in a specific month between two dates
I'm working on a program tracker that includes revenue forecasting in each month. Project durations can range from one week to six months or more and I want the revenue to be forecasted evenly over the duration of the project. A date formula that calculates the number of days in a specific month between two dates would be…
-
If / Or Statement not working
I have a what I thought was a simple If / Or statement for calculating NETWORKDAYS in Ticketing sheet. Short explanation, when a ticket is opened it is assigned a SLA based on Priority (Critical=1, High=2, Medium=3, Low=4). While the ticket is open the Actual SLA is tracked by NETWORKDAYS. When the closed is closed the…
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
Help with COUNTIFS function with external references where first variable has multiple choices
Hi, I have a sheet with ranges identified as SUBJECTM and FLAGM. On my summary page, I have a list of all variables, with the column identified as Metric. In the main sheet, the subject field is a series of checkboxes with the ability to select multiple options (think : maths, english, french, art). I want to count the…
-
Date functions in IF Statement
Hi, I'm trying to get the previous month and previous year via a formula. Here is the formula I am trying to use: =IF(MONTH(TODAY()) = "2", MONTH(TODAY()) - 1 + "/" + YEAR(TODAY()) - 1, "false") It works when I remove the -1 from the YEAR(TODAY()) - 1 part, but when I add the -1 back in I get #INVALID OPERATION. Any ideas?…
