-
Vlookup Contact List... Recognition after Save
I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not recognized after a couple seconds of being open and thus is not brought into a filter…
-
I have been trying to think of a way to get around Smartsheet's lack of a =FILTER function?
I have been trying to think of a possible work around for an =FILTER type function, I have been using Smartsheet for a few months now and the last thing I need before I can fully move over to Smartsheet from google sheet and excel is a auto-generated summary sheet based off a a row in another sheet. I will attach some…
-
How to return more than one value with multiple serach values with vlookup
Hi, I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C. My Question here is when I need to show multiple values based on multiple IDs. Example: If ID1=Result1 ID2=Result2 and ID3=Result3 and in ID column I write 1 2 or something like this and i want to…
-
Calculations based on form field entries for data validation
I'm creating a form in which staff enter #s into each of several fields. They need to total to 100 (percent). Is there any way to at least show the total live in the form or, preferably, enforce that they add to 100?
-
Help with multiple IF (CONTAINS) AND OR criteria
Hello! I'm trying to figure out how to write a formula to return a value of "Open" or "Closed" when multiple criteria is met, or leave blank if N/A. Columns: "Issue Category (Consolidated)" column contains selections "Invoice Mgmt", "Inventory", etc. "Status" dropdown column = Not Started, In Progress, Completed,…
-
IF and OR nested functions for setting Due Dates based on Project Size
Hi folks, I've been Googling around to try and find some information regarding my challenge. Basically I need to set up this formula to assign a Projected Due date based firstly on the Date of Submission (Date Column) +5 days for a small project or +10 days for a Large project. I have columns filled through for entry for…
-
Using IF and OR function in a formula
I am so close to getting this, but each time I tweak it, I get an UNPARSEABLE message. I am trying to get the Column Titled: Duration (In Hrs) to zero out if EITHER the Not Applicable or Optional rows are checked. The below formula is only making my column 0 out if BOTH the Not Applicable and Optional rows are checked. I'm…
-
#INVALID OPERATION - Error
I'm trying to write an IF/AND formula that references a different sheet to return a single row value. I think where I'm running into a problem is that I need the formula to evaluate three entire columns of data to see if the criteria are met, then return a row level value if all criteria are met on that single row. New…
-
VLOOKUP + Reference Another Sheet
I have been trying to VLOOKUP a value from Sheet A to a table in Sheet B and continue to get #UNPARSEABLE - here is the example I am working with and the formula: =VLOOKUP([Primary Column]3, {test4 Range 1},3,false)) All columns are Text/Number format, the lookup value is in the left-most column. The VLOOKUP formula works…
-
INDEX MATCH Question
Hi everyone, I need a quick hand with an INDEX MATCH formula. I have a form that has users select their store from a drop down. I have two formula columns that use this entry: Region and then Regional Sales Director (RSD). I need to pull Region and RSD from a separate sheet that I don't manage. The column layout is shown…