Sign in to join the conversation:
When will we have the ability to VLOOKUP a value on another sheet? I link to a cell in another sheet now when the location is static....but in this situation the value is not in a certain cell.
Hi Joe,
We're planning to release cross-sheet formulas in the first quarter of this year.
In the meantime, as a workaround you could cell link the entire table from the other sheet (using Copy --> Right Click: Paste Special --> Links to Copied Cells), then use LOOKUP as a same-sheet formula.
Best regards,
Daniel
I just noticed they've added this vlookup function to look at other sheets, yet i still have to figure it out how it works
You can now reference data from other sheets in formulas!
Create a master lookup table sheet and use VLOOKUP to find data on another sheet.
More information on this new feature is available in our help center: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
THANK YOU so much for adding this functionality to SmartSheet!!
I am trying to use VLOOKUP to another sheet on a CONTACT column-type. However, SmartSheet is not letting me enter the formula in the column when the column is a CONTACT type. I tried changing the column to a TEXT/NUMBER column-type, which appeared to work initially. However, when I pulled reporting based on the CONTACT criteria (i.e.: Designer=Jenny), the report is not working correctly and cannot 'see' any contact in that VLOOKUP column. What's the recommended workaround for this, and when will this issue be fixed? Thank you.
Hi Caroline,
Currently, formulas aren't allowed in Contact list columns and there currently isn't a workaround to allow formulas in Contact list columns.
When you have a moment, please submit a Product Enhancement Request using the form under Quick links on the right of the community site to let our Product team know that you'd like to see this feature added to Smartsheet.
Formulas in contact columns. It's released now!
https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…
