-
Can I have just one cell automatically copy over from 1 sheet to others when a new row is added
I know there is a workflow for copy row if row is added or changed. I don't want that, since it will copy all of the columns. I have 1 Master List of Names. The other sheets are specific trainings and prerequisites. I will have columns on the master list that don't need to be on the other sheets, and vice versa. I figure I…
-
Changing / Moving Existing Profile Data - Intake Sheet to Project Sheet
Hi!! We have a large program & want to change where some of our Profile Data fields are being entered without breaking things / renaming fields / doing a ton of avoidable repairs. I'd love some advice on common issues / the best approach! ------- Program Setup (for reference if needed, feel free to skip to the goal 😊) Our…
-
Ich möchte Zeilen mit verlinkten Zellen (incl. aller Links) in ein anderes Blatt kopieren
Ist es möglich beim kopieren von Zeilen zwischen zwei Blättern, Zell-Links ebenfalls zu übernehmen? Über den Befehl "In anderes Blatt kopieren..." gehen leider alle vorhandenen Verlinkungen im Zielblatt verloren. Vielen Dank für Tipps und Tricks, Miranda
-
2 views from the same datasets
I'm working within gov trying to create 2 different views from the same datasets. I have a sheet for a given project that includes the staff (in rows) and the number of hours to work on that project for a given week (in columns). I have multiple sheets of this information (for multiple projects). The project view…
-
Help with Trend Data
I need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. Ex: How many projects are Red, Yellow and Green. This works really well for live data.…
-
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…
-
Duration and Date Dependencies - Reference Cell in Same Sheet
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm trying to have the information in the Project Summary cells pulled into highlighted durations/dates so that it doesn't have to…
-
Does locking a column in the destination sheet prevent cell links from updating?
Hi All, We're encountering a problem where cell links are not updating. There are numerous project sheets (a few hundred of them) that each have a set of cells linked into a master sheet. When the owner or admin of the sheets makes an edit in one of the project sheets, the master sheet receives the update via the cell link…
-
Automation using reference cell
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this monitoring is measured as the stages are marked as Complete. This calculation is straightforward with a formula that…
-
Duplicating sheets to have different conditional formatting on reports
I have 5 different sheets representing 5 different projects in 1 program of work. So I am creating reports to bring those 5 sheets together to get a program level view. For one report, I want to see timings in a gantt view and color the bars based on the project sheet. However, I can't do this without changing the…
