-
Help with collect formula with multiple AND arguments
Hi folks, I am currently using this formula, which works fine: =IFERROR((AVG(COLLECT({#Working Days to Kickoff with KP}, {Verizon Received Date}, AND(@cell <= DATE(2023, 1, 31), @cell >= DATE(2023, 1, 1))))), "") This gives me the average time we take to kick off our projects from the date we receive our projects from the…
-
Auto populate project ID based on identifier
Is there a way to auto populate a letter and number ID sequence based on an identifier? I'm trying to create a project ID based on business segment, state and have a number auto generated, but be sequential within the business segment. Ex: AB_FL_0001 AB_CA_0002 AB_FL_0003 CD_NY_0001 CD_LA_0002
-
If cell checked, pull in different cell value
I'm trying to pull a value from a cell into another cell if a different cell has a check mark. If the cell for the column 'Full Payment Received? is checked, insert the value from 'Amount of Bonus Owed' I've tried the following: =IF({Full Payment Received?}@row = 1, {Amount of Bonus Owed}@row) Thanks in advance for your…
-
Sheet Summary Countifs on columns with formulas
I'm trying to build sheet summary metrics utilizing countifs against multiple columns but the column ranges themselves have vlookups in it. Unless I hard code the column values so that they are static, my formulas won't work and giving the [No Match] error for my criteria. Is there a workaround for this?
-
Date Calculations
Hey y'all super new to this, I am trying to have the goal date be based on the Target open date less the days prior. The formula I have is " =Description1 + [Days Prior to Opening]@row " which returns the above. What am I doing wrong and how to do I fix it? Dependencies are turned off.
-
How to write a divide formula?
I have a formula that im trying to make that adds 3 criterion and divides the sum by a value. Can some one help with that what looks like.
-
vlookup question (sheet to sheet)
I think I need a VLookup formula but I'm stumped. I have 2 sheets where each row of data has an individual row number in a column--the data in each row is exactly the same. I need a formula on the secondary sheet to check the row number on the master sheet. If the row number on the secondary sheet matches the row number on…
-
Looking to Resolve #NO MATCH with a Multi-select Dropdown
I've tried many variations and got very close with: =IF(CONTAINS("Orientation", Course@row), INDEX({Course Start Date}, MATCH(Course@row, {Courses Dropdown Name}, 0)), "") - it only pulls when there is one selection provided in the multi-select dropdown and a "#NO MATCH" where there are more than one course selected. We…
-
VLookup Question
Hello, I am looking to compare two sheets each month. I have VLookup searching for 4 individual pieces of information from the Monthly Sheet within the Master List: Employee, Merchant, Date, Amount. Currently, I have =VLOOKUP(Employee@row, {Master List Name}, 1, false) that looks for the Employee Name and will either…
-
Looking to Countif a person's name is contained in a column that allows for multiple contacts.
=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row)) the OTP Goals Project Lead is the sheet that has the column that is a contact list that allows for multiple contacts. If a person's name is contained in that column and it matches the name in the column on the metrics sheet called Contact - then I want it to count…
