Hi @Tyler_Cook and Welcome to the Community 
!
I’m not sure to understand how things relate to each other here 
, but …
As you seem to store your different buttons in a canvas columns in the project table, I think you can simply add in your buttons, for :
-
Project → thisRow (this will return the reference of the project you’re currently in)
-
Workspace → thisRow.Workspace (this will return the workspace selected in your Workspace field for thisRow (I.e.: the row of the Project you’re currently in)
In the sample you’ll find below, you’ll see this Action formula in the buttons I have in the canvas column to create 5 tasks for whatever project I’m in :
Sequence(1,5).ForEach(
RunActions(
AddRow(
[Tasks 2],
[Tasks 2].Tasks,
Concatenate("Task ",CurrentValue),
[Tasks 2].Projects,
thisRow,
[Tasks 2].Workspaces,
thisRow.Workspaces
)
)
)
And these are the “interesting” parts of the formula 
:
For the Projects :
...
[Tasks 2].Projects,
thisRow,
...
In other words, for the column Projects in the table [Tasks 2], return thisRow (The currently opened Project)
And for the Workspaces
...
[Tasks 2].Workspaces,
thisRow.Workspaces
...
In other words, for the column Workspaces in the table [Tasks 2], return thisRow.Workspaces (The currently selected Workspace for the currently opened Project)
Sample 1.1 : Not using template for the Canvas column of the table [Projects 2]
Sample 1.2 : Using a template for the canvas column for the Canvas column of the table [Projects 2]
Now, unless you absolutely need those 2 lookups to be manually editable, another way to get your projects and workspaces directly linked to the tasks on creation could be to use in your Tasks table:
- 1 manual single-select lookup for the
Project
- 1 “related column” to the
Project lookup → Workspace
As, as far as I can see, your “new project” seems to be already linked to a specific workspace on creation…
This means that when you create a new project, it already belongs to a workspace and this link could be reflected in your Tasks table either by :
- Adding a “related column” from the
Settings of your Project lookup field in your tasks table
or
- Add a simple formula such as
thisRow.Projects.Workspaces to your Workspace lookup in your Tasks table
This will retrieve the Workspace to which the Project is linked
And when adding the tasks in your Tasks table, all you would need to do is to specify to which project the tasks should be linked in the same way it’s done in my previous sample (i.e.: the value the button should return for the column Project should be thisRow) and the Workspace would be formulaically gathered there .
Sample 2.1 : Not using template for the Canvas column of the table Projects
Sample 2.2 : Using template for the Canvas column of the table Projects
I’ve simplified what I understood from your workflow here so I could be completely wrong … But I hope this helps
If something’s not clear or you have other questions, don’t hesitate 
!
