With the new cross-sheet VLOOKUP function, how many VLOOKUP cells can exist in one sheet? Does the limit change if there are both inbound and outbound VLOOKUPS in the same sheet?
As our company admin for Smartsheet, I typically deploy all-new Project Workspaces - this provides me with the opportunity to assist team members if they become stuck, or have an issue; I can then problem-solve with them within their workspace. This leads to an issue where I have many, many Workspaces visible, of which I…
Hello, I have two related SmartSheets covering different aspects of my data. I would like them to refer to each other so that I can ultimately pull certain aspects into a report. I prefer to use SmartSheet over SQL in order to take advantage of the workflow and approval capabilities. However. I cannot figure out how to…
This discussion has been merged.
Good evening, I'm looking for some assistance :) I've been trying to find the formula that alows me to join 3 columns value of the same line of the match. This is between 2 smartsheets. I made a quick draw of it. I would appreciate any help :)
Hi, I'm trying to get sheet A (vertical view) into sheet B view (horizontal view). Sheet A: Sheet B: the helper column date is in txt/number so it would match sheet A. Could anyone help? Thanks. :)
Hello! I am looking for assistance with a formula that can pull in the next action date from one sheet to another. For context, we use sheets for customer renewal project plans. We also have a tracker that gives an overview of all the project plans and their name, completion, next action date, status, etc. What I would…
Hello! I have a quick question regarding copying and inputting data. I am aware that rows can be moved or copied into other sheets via workflows. However, is it possible to create a workflow automation that copies/replicates data in "Cell A" into "Cell B"? The column properties of all the cells are set to Text/Number. I…
a