Cell linking issues while filling from from

Joseph Aloysias

Cell linking is disappearing automatically when we fill out the project intake sheet form.

I have a project intake sheet that I use to feed new project information and from project, metadata sheet to the project intake sheet I created link to get the data when the project intake form is filled, but this is not working

Andrée Starå

Hi @Josephcopernicus

I hope you're well and safe!

You'd need to use a cross-sheet formula instead. (VLOOKUP or INDEX/MATCH)

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Joseph Aloysias

for (VLOOKUP or INDEX/MATCH) we need to have a prebuilt static value to match the data, but how we can have static data to match when we are filling out a form? Is there a way to do that? please suggest

Joseph Aloysias

Hi,

I have prepared template set for all projects and have link to other sheet, that template set will be used for new projects but linking data to other sheets are not happening when I copy the template set for new projects.

Is there way we can manage this?