Formula for Cross-Sheet References Based on Row/Task Information

Lori.P

Is there a way [in the Core App - without Control Center] to create a formula that pulls in data from another sheet via cell linking, but is set up in a way that it can be used in a repeated use template?

To give an example of what I'm trying to do: I have a set of projects that are fairly consistent as far as activities. I'd like to pull in "Actual Release Date" from each project plan into a primary tracker for all projects. The "Actual Release Date" would be based off of a date cell in a row for a specific activity that's tied to the actual release. This date may change based off of other activities/tasks getting shifted or ad-hoc items getting added to the project plan (not super common but it does happen), so it needs to be directly linked from the project plan.

I can't figure out a way to write a formula that says (basically): pull in DATE from THIS CELL for a template project plan that will pull into the primary tracker the same way every time.

I've probably overthought this and done too much research and it's likely simpler than I'm making it :) I tried using the AI formula generator, but we can't do cross-sheet references with that yet.

Paul Newcome

You would need to use the API, the premium add-on Bridge, or some other third party app to do this without Control Center if you do not want to manually create the cell link each time.