Hi, I use a Google Doc template to generate work orders for a service business. We are changing how we add parts to a work order from a hardcoded method to a virtual column of parts used that references back to the job number they are used on.
What I am not certain of at all is how to modify my Google Doc template to list the parts and quantities used for each row showing as part of a job number.
Any hints as to what function I may use? I’ve been toying with a Lookup but it looks like it will only return a value, not a potentially list of values of more than 1 type of part is used on a single job.
Thank you for the help in advance!
Thanks,
Justin
LinkedIn
Twitter
