-
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.
-
Formula Help Calculate # of Days with 2 date fields, unless date field is blank use todays date.
I need a formula for column "Days to Build" I want the number of days it has taken to build using Build End Date - Build Start Date = Days to Build, but if there is no Build end date I want it to be today - build start date = days to build.
-
Using ISBLANK when a field is not blank to autofill in a checkbox
I am creating a complicated workaround since when requesting an update (apart from using a form) Smartsheet can't require request for update fields to be filled in. So, I need to run an automated workflow update request on fields left blank (that arrive after the enterer sends the update, not at the same time). In order to…
