Help plotting on Map
What is the best way to plot points and data on a map.
What I am looking for is a way to use a single map to show different jobs.
We create a job by copying a template of sheets. One of those sheets are the "data" sheet that holds the Job Name, Job Address, Project Manager, and Phase. All of these are in their own columns.
So when we create a new job we copy the template and rename it.
Say we have 10 jobs all with different "data" sheets with the above info. Any suggestions on how to show the jobs on a map according to phase and then by project manager?
I looked into mapsley and for that to work well you need all the data on one sheet.
Any suggestions on where to start?
Help Article Resources
Check out the Formula Handbook template!