-
Merged: Add a row at the Summary Sheet thru Global Update that can be linked back to the Intake Sheet
This discussion has been merged.
-
The intermediary sheet not updating with the source
Hello, I have a destination sheet that is cell linked to a source sheet. The source sheet is constantly being updated (adding information, deleting information) but the destination sheet does not reflect those updates. Is there any work around this issue? Any way that the destination sheet reflects the updates real time? I…
-
Copy of PMO suite
Hello I am new to Smartsheets! I have my PMO suite and when I made it I made a copy of it incase i broke something. I broke my metadata sheet and lost all the formulas. I did figure out how to put them in but there a ALOT of sections to fix. My question is can I just copy my copy of my meta data sheet into my old folder…
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…
-
How to Get Attachment to Work on Automation
Hello All! I have an automation that is set as Trigger: When a Date is Reached —> Run Once on Date at 5pm. Conditions: Where two separate checkboxes are checked. Alert someone—> Message, Link to sheet and specific fields (an attachment). The automation worked except the attachment. It wasn't included at all on the…
-
Continuously update a single cell from a regularly updating form?
Hi, I'm new to Smartsheet and was asked by a colleague if this was possible. We're tracking maintenance needs for on-site business assets that will be managed by a large group of employees. I have a sheet with each asset and their subsequent maintenance needs, plus fields for date of most recent update for each. I want to…
-
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,…
-
Gantt Insert with Dependency Mapping
I would like to suggest a feature that allows users to insert or embed one Smartsheet Gantt/project plan directly into an existing sheet without creating a separate sheet. Ideally, this functionality would preserve all existing dependencies (predecessors) from the original plan while dynamically updating them to align with…
-
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…