Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Map for Location Data

Hi,

Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet?

Thank you!

Best Answers

  • Moderator
    Answer ✓

    Hello @A Rose

    At this time, Smartsheet doesn't support that specific feature but its a great idea! Please submit an enhancement request on this to be considered for the future development of Smartsheet.


    In the meantime, I suggest looking into Zapier. It's an integration that allows for third party automations from different apps. I found a few map-related apps that Zapier supports.


    Cheers!

    Krissia

  • ✭✭✭✭✭
    Answer ✓

    Hi @Krissia B,

    Found a little solution!

    We can imbed a google map into a dashboard!

    (but the google map needs to be public, and updated with the Smartsheet content by exporting and importing..)

    Thank you!

  • ✭✭
    Answer ✓

    Hi @A Rose ,

    While Smartsheet indeed doesn't have any native solution for showing data on the map (Smartsheet Maps became deprecated last year), I suggest trying Mapsly which is a location intelligence platform that directly integrates with Smartsheet and can display points on the map based on the address column. You don't have to worry about manually importing new data or updating color of your points as this all happens automatically. I suggest giving it a try since there is a free 14-day trial and the support team is available 24/7 if you have any questions.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

  • I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
    User: "Allan Z"
    Answered ✓
    9
    2
  • Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
    User: "stratman"
    Answered ✓
    15
    2
  • I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …
    User: "m_anderson"
    Answered ✓
    13
    2