-
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…
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
Anyone else experiencing EXTREME delays with cell linking?
I'm noticing SEVERE delays with cell linking lately. As in over 15 minutes before the cell populates. Our plan includes tech support, so I called yesterday. They said "up to 5 minutes is normal" I'm at over 15 minutes with no data being pulled down from the other sheet.
-
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…
-
Change How Dependencies Appear? - Would rather see task title vs row number
My engineers and technical team(s) have requested a bounty list be created. Obviously setting up a dependency is easy enough; however, it would be be more useful to see the task name that the task is dependent upon instead of the row number. Is there a way to do this by changing a setting that I don't know about? Or would…
-
Issue with inter-sheet cell linking returning blank cells
Hello all. I am having an issue, and it may be a very disappointing deal-killer. I am a national program manager and have taken on one of our organization's largest programs. I am attempting to evaluate smartsheets as a potential MS Project replacement. Issue In Project 1 (P1), I create a link to a task in Project 2 (P2).…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…
