-
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…
-
Auto Generated Number formula based on value in another column
I need help with a formula: Need auto-generated number based on: If value in "type" column is "Type1", auto-generate number in column "number" , otherwise, leave blank Cannot use Auto-Generate number column because of criteria Can make column formula to ensure auto-generated number is in new and existing rows
-
INDEX/MATCH formula assistance needed
Hello. I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.…
-
MULTIPLE IF FORMULA AROUND DATES
Hi: Can anyone help with a Multiple If formula which i cannot get to work please? I have a Valid To Culumn with a date in it and have a Status Column i want toi flag as CURRENT, EXPIRING or EXPIRED depending on the date. I had CURRENT & EXPIRED working but when i try to include the additional IF to show as EXPIRING if the…
-
Formula HELP... Display number only is formula results in less than ZERO
# of Contracted eDocs - # of Submitted eDocs = Need Contracting; IF the number is less than 0, I do not want a number to display in the Need Contracting field unless it is negative.