I'm new to Smartsheets and I'm trying to figure out how to do an IF([Response]3="Yes", VLookup formula linked to a reference data sheet. I've tried various ways to input and always get Unparseable. Any help is appreciated!
You have to create that reference in the little drop-down data that appears while typing in your formula. Then you will select your range and finish the formula.
See screenshot below for reference.
But my initial IF is based on a field on my current sheet then I lookup my reference sheet hours based on that answer - first true then false.
You should be able to apply the same methodology to set your vlookup... =if(x=x, Vlookup( -- choose the external reference when you start typing this.
See screenshot below.
I know I'm not doing this right - LOL. Here is what I have and still not working - I feel like I'm missing the logical expression in my referenced sheet, but I'm just not sure...
=IF([Office Test Lab]1="Yes", VLOOKUP({Apexstamator Reference Data Range 2}"Lab Test Office Yes",{Apexstamator Reference Data Range 1}, 2), {Apexstamator Reference Data Range 3})
Try troubleshooting by comparing your lookup to the instructions found on the function post itself. Or the limitations as seen on the second article.
Those might give you some clues as to how you should set it up.
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
