-
Multiple If statements
Hi, hoping someone will be able to help with an issue I am having with an IF formula. I am attempting to build an IF formula from check boxes, however it isn't as simple as multiple IF statements returning their own responses. What I am trying to achieve is a status update column, based off of the checkboxes. And therefore…
-
Compare Text between columns, one with text, one without, and return the text.
I have created a form that is for use with two separate groups, fields become available dependent on how respondents answer questions. I have a VLOOKUP formula set to pull in the address information from another sheet. Because this is used between two separate groups, there are two name fields. I am trying to compare both…
-
Sum cells in varying column length with if-then?
Not sure if this is possible. Column can vary from 2 to X cells A couple of scenarios: A column two cells with 12 and 14. Total is 26. In the resultant cell 16 is inserted. (any sum of 17 or greater the number 16 is inserted) A column has a number of cells that total 14. Seeing that the number is less than 16 the actual…
-
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…
