-
How to write VLOOKUP to source data from multiple sheets
I have a Master Project sheet and multiple individual project sheets. I need to gather one piece of data from the individual project sheets to write into the row on the Master Sheet. While VLOOKUP will work, the wizard requires me to know the sheet that I want to search. I need to reference all sheets in a workspace as the…
-
Linking data from multiple sheets to one master sheet - then to a dashboard
Context: I have a team of people with their own individual smartsheet trackers that each contain identical columns. I want to have the rows on those individual trackers automatically populate/update in one master tracker where I can see everyone's data at once. I have already tried reports - this doesn't work for me. The…
-
Can I pull in information from one sheet to another when there are multiple matches?
I have a budget tracking process I would like some help setting up. See steps below: Employees fill out a budget request form for office events. On this form, they state the name of the event they are hosting, which office they represent, and how much they are requesting from a pot of funds. This is stored in the Primary…
-
Cell Links from Intake Sheet to Profile Sheet
Hello all! I am a relatively new SS Admin and would like some assistance understanding the Profile Sheet - Intake Sheet Relationship. I just added new data items to the Profile Sheet via the Global Updates in Control Center. However, in the new partitioned blueprints, there is no incoming (blue arrow) cell link from the…
-
Is there a quick way to identify or List all the Smartsheet Links?
Hi There I have a worksheet that I have inherited, and need a way to identify all Links from a cell in other sheets. Is there a report of function on Smartsheet for this? Thanking you in advance for your assistance. Warmest Regards Dickson
-
Finding the oldest date on multiple sheets and also based on text in another cell
I have 2021, 2022, 2023, 2024, and 2025 sheets with different departments' requests for action (RFAs). I am looking for a formula to show me the oldest open RFA for each department. Some departments will be in 2021, but some will be in 2024. A sheet summary formula is not what I am looking for. I need a reference sheet…
-
Copying a one cell to another between sheets
I am trying to copy a specific cell from my main sheet to another cell on a different sheet. I have tried using the cell linking feature where I right click the cell I want the information to go and select "link from cell in another sheet" then select the cell I want on the main sheet and select create link. When I do this…
-
Pull Cells Only From Another Sheet With Criteria
Good afternoon all, I am trying to figure out how to have certain cells pulled over to a row on a new sheet when certain criteria are met. I want the purchase order number in the purchase order column to pull onto another sheet only if the REQ # matches. The purchase order number shows up in the purchase order column that…
-
Merged: Single Cell - Locking
This discussion has been merged.
-
Create a what if scenario using a late start date
I am working with a project timeline with dependencies. I have set up 2 additional date columns for late start and late finish where the late finish date is a formula for late start @row + duration. How can I set this up to calculate all the dependent late dates for start and finish? For example, I have several activities…