Reference Sheet - Include All Cells as Cells increase

gwen.pino78261
gwen.pino78261 ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I modified a template package for Project Management that has a form that enters project requests to a sheet.  A Project Plan Template uses vlookup back to the project request sheet to enter project specific information to the plan. 

Problem:

I need to extend the reference cells every time a line is added. 

 

Ask:

How can I configure the reference sheet so that the vlookup just includes the whole sheet.

 

thanks

Comments