Reaching out for help to overcome a formula issue. My ultimate aim is to have a bubble chart to track up to 2000 people going in and out of a few cities over time with a background map. Instead of entering long and lat data each time, I’d prefer to type in a city and have long and lat auto populate. I have “city” “long” and “lat” columns (numeric ddd geospatial) and created a formula along the lines of ...if(city=“city name” then = “26*E”. Unfortunately it doesn’t work and the formula changes the numeric geospatial “long” column from numeric to character.
1. Any suggestions on how to fix this error?
2. Suggestions on other ways to achieve an auto populated long lat lost by city?