Button to update cell value with lookup

Hi Everyone!

I have a page with all tasks including

  • a table with projects A B C D
  • a table with tasks + lookup to associated project

I have a page per project with

  • a table with tasks linked to project B
  • a button to add a task

I am trying to have the button automatically assign the task to a give project.
Any clue on how to do it?

I have “=project” but don’t know how to redirect to the specific project I had in mind.

Thanks in advance for the support!


In order to get the correct item in the Column 2 button, type “=@Project B” (without the tick marks).
On every project page you make a button with the right project for column 2.

Open for editing makes sure that you actually start entering some task text, but you don’t have to do that if you want to follow a different approach.