-
Creating Project Planning Sheets from a Template, Linking to Master Sheet
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…
-
How to Connect Data from Project Metrics to Portfolio Summary
Could someone provide guidance on how to link data from the project metrics back to the Portfolio Summary after a project has been provisioned? I am trying to connect timeline finish dates & status dates back to the Portfolio Summary. Thanks!
-
Scheduling Calendars Switch to Smartsheet
Hello! We have a scheduling team that is working out of 5 Google Sheets they created to look like calendars - each tab is a new month and each role they schedule has a different Sheet. There are different scheduling rules to take into account with each role type which makes it nice to see them separately. Their current…
-
Linking Columns Across Multiple Forms
Hi! I want to link two columns (Pre-Assessment and Post-Assessment) from my Learner Management Tracking List to my Leaner Data Jan - Dec 2026 sheet. I know who to do the formula. My concern is that the Learner Management Tracking List is live data and we create a new data sheet every year. In 2027, would we just edit…
-
Index/Collect?
I am looking for a formula that will take the "Date Manufacturing" entry for a specific lot number from Sheet 1 (my source sheet, see attachment) and have it automatically populate into a corresponding cell onto a secondary sheet (attachment 2) into the row "Date of Manufacturing" for that specific lot number. I have the…
-
Can we auto create the Row Link as a Hyperlink to autoconnect to that row yet?
Please tell me this is available. It would be nice to be able to create a column on a sheet that will automatically create a hyperlink to that particular row!!!
-
Multiple Projects into a high level Programme / Portfolio Project
Hi Clever Community, Sorry to ask this question as I believe I've seen the answer but that was 4-5 years ago and I cannot find the article now. So I have 4 projects, each with a suite of smartsheets (all from a template) including risks, actions, milestones and timeline. So each of the 4 have the same fields and layout…
-
What is the best way to bring in data from another sheet without a direct matching column on both sheets?
My goal is the bring in contact information (Name and email address, 2 separate columns) from a reference sheet {Sheet A} to my target sheet {Sheet B}. I've used {Sheet B} as a reference on many other sheets for the same purpose, however, the data on this particular target sheet is inconsistent with the reference sheet.…
-
Sum if Multiple criteria matches across 2 sheets
Hi, I have two sheets containing a table of items. Sheet 1 is for entire item list and sheet 2 is for items used in a day. I want the sheet 1 to check the sheet 2 and reduce the numbers in the sheet 1 automatically. The problem I need to match two criterias. I tried following after making it work for one criteria. Any help…
-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.