IF function combined with Vlookup in 2 different smartsheets
Hello!
I have another beginner question. Is it possible to combine an If conditional with a Vlookup?
This is my scenario:
I have 2 sheets:
Summary and Form.
Columns in each sheet are:
Summary Sheet:
-Column Name
-Column Question #1
Form Sheet:
-Column Name
-Column Quarter
-Column Question 1
The result that I need:
I would like to bring the value in Column Question 1 (from the Form Sheet) to the summary sheet, but only if the quarter answer is x.
Is this possible?
I hope I explained myself.
Thank you!
Comments
-
Screenshots may help us better find an answer for you.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
I attached a print screen.
Thank you for your help.
-
I just want to make sure I'm clear on what exactly you're looking for...
You want the information from the bottom screenshot to determine which section of the top screenshot it goes in?
In answer to the first part of your question: There are no functions that I am aware of that will place a row under a specific parent row within a sheet. There are a few different options for workarounds though. One would be sorting within the sheet. Another option is having a summary sheet with all quarters combined (no particular sort order), and having a report for each quarter that looks at your sheet.In answer to the second part: It is possible to use VLOOKUP within and IF statement as well as an IF statement within a VLOOKUP.
Sorry if this isn't the answer you're looking for. I'm having a little trouble figuring out exactly how your original post and your screenshots fit together.
If all you are trying to accomplish is to populate a specific cell based on specific criteria you would not necessarily need a VLOOKUP function. It would be something along the lines of:
=IF({Form Sheet Range 1} = "2 Quarter", {Form Sheet Range 2})
{Form Sheet Range 1} would be the cell you want to use to determine the criteria.
{Form Sheet Range 2} would be the cell you want to pull the data from.
There are a few issues with this particular setup.
1. You would have to create new range references for each cell.
2. You can only have 100 unique range references on a sheet. Since you have 2 for each row, you would cap it out in just 50 rows.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
You gave me the answer. Yes!
Thank you so much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!