I have received two Schedules from a client and their designer and need to link them so that updates to each one is reflected on the second.
Is this possible?
Hi @P Broomberg
You can set up a one-way sync by using Cell Linking to bring data from one sheet into the other, see: Cell Links: Consolidate or Maintain Consistency of Data
Depending on the sheet set-up, you could also use cross-sheet formulas to bring in data from one sheet to the other as well. See this other Community post for an example: Need a Clear Example of Using INDEX and MATCH in lieu of HLOOKUP
An alternative would be to create a Report using the two sheets as the source. This would allow you to see the rows from each sheet in the same place. Any edits you make in a Report will then update the underlying sheet(s) as well. See: SmartStart: Reporting
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
I have an automated workflow that requests a form if certain fields are blank. It's triggered when a new row is added or changed. More specifically, the automated flow is activated when a required field is added or changed. This works fine. However, the automated flow doesn't issue a follow up form request when some of the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.