Sign in to join the conversation:
Hello,
I am trying to use this formula:
=IF([Column2]5="","",(IF((VLOOKUP([Column4]5,'Combined Timesheets'!A:[Column2],2,FALSE))=[Column2]5,"Yes","")))
It wont work and I keep getting the #UNPARSEABLE error. Can anyone help me fix my formula?
It looks like you may have an excel tab reference 'Combined Timesheets'! in the formula. Can you write out in words what you want the formula to do?
If Column2 Row5 equals a comma, Then (value if true) (value if false)
If you have more conditions to evaluate just indent as needed. I think this will lead to a better structured formula in the end (using index/match, OR, @row). Looking forward to your response.
=IF( [Column2]5="","", (IF ((VLOOKUP([Column4]5,'Combined Timesheets'!A: [Column2],2,FALSE))=[Column2]5,"Yes","" )) )
There are several potential issues I see with this formula... which makes the final one not-needed. Also there is what looks to be an excel or Google sheet reference to an alternative
First there is an extra open parenthesis before the 2nd IF statement
=IF([Column2]5="","",----> (<-----IF((VLOOKUP([Column4]5,'Combined Timesheets'!A:[Column2],2,FALSE))=[Column2]5,"Yes",""))---->)<-----
Second, it looks like there is a reference to a separate google sheet that might have come when you ported this over from Exel or Google. This could also e causing the problem.
=IF([Column2]5="","",IF((VLOOKUP([Column4]5,----->'Combined Timesheets'!A:<------[Column2],2,FALSE))=[Column2]5,"Yes",""))
Thanks for your reply,
I imported several tabs from an excel workbook and many of them contain referencing formulas. I imported the formulas as well but its not working in smartsheet.
Referencing another sheet in Smartsheet is VERY different than referencing another sheet in Excel.
Here is an article from Smartsheet on how to reference other sheets...
https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
Hello, I am trying to create a formula that will separate text. I can't use the Left or Right and the length of names is different. Example: I need to return the first name only in a different column. Format is LastName, First Name Full Name First Name Smith, Joe Joe Jones, Ralph Thompson, Leah Robbins, Sam Robinson, Sally…
For my Customer ID column, I'd like to count how many cells have errors so I'm trying this: =COUNTIF([Customer ID]:[Customer ID], not(iserror(@row ))) The Customer ID column is a lookup from elsewhere, and typically the error that could show up is #NO MATCH. I've tried a few variations of this formula but can't get it to…
I seem to have an issue only if I'm using the default Start/Finish columns in a project plan template with a formula. I need to have a Start date X days after Go Live but it won't accept that a formula is a formula when I use the template columns but it will work if I create my own data column. Here is the formula: =([Go…
