-
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…
-
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…
-
Formula to make a metrics sheet to build a pipleline dashboard
I have a sales tracker sheet and need to continuously pull data as new quotes are formed to show wins/ losses compared to our target in a dashboard. Sheet has 3 columns that need to create the formula: Account type, Weighted Forecast, and Expected Quarter Close. In real words, I want to say Weighted forescast is $1M for…