Best Of
Re: ESRI Integration: Does anyone have an existing solution for ESRI↔Smartsheet? (GIS/ArcGIS)
Hi @NeilKY,
It looks like the Skyway integration may be the only existing integration for ESRI and Smartsheet. The alternative would be to use the API, but I understand that you’re looking for something that’s already set up. I’d recommend adding your vote to the following product idea and adding a comment as to how this would help you:
I also found this blog post in the ESRI Community which may be useful if you haven’t already come across it: Updating ArcGIS Online hosted feature layer with Smartsheets using ArcGIS API for Python
Hope that helps a bit!
Georgie
Georgie
Re: From ESRI GIS to Smartsheet
@NeilKY Unfortunately, we did not. I'm thinking about taking GIS data from SQL into Smartsheet using the ODBC connector, but have not tried that yet.
ljkeefe1
Re: What equation should I use for a floating Quarterly budget total
Not sure how others solve for this type of thing, but my solution has been to create what I call relative date columns that simply look at a date field and determine if it is "This QTR", "Last QTR" or "Out of Range" (I don't need future for what i'm reporting, but it would be simple to add). They are just nested IF statements. I do this for Year, QTR, Month and Week, and will then use a combination of filters in a report to get the data I want (e.g. "This Year" and "This QTR"). Sounds like you could add these columns to your metadata sheet and then report against that. Hope that helps.
Adam Murphy
Re: INDEX LOOUP Workaround
Excellent!
Happy to help!
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Upcoming Virtual User Groups - Register today!
📢 Attention Smartsheet Community members - we’ve got a few virtual User Groups coming up, and we’d love for you to join us! These sessions are a great way to connect with fellow Smartsheet users, discover best practices, and pick up new tips. Can’t attend live? Be sure to register anyway—we’ll send you the recording so you don’t miss out.
Executive insights on Smartsheet adoption - May 15 - REGISTER HERE
Will Jeffords, VP of Business Operations at Swampfox Technologies and a Smartsheet Overachiever, will offer tangible advice and examples of how they drive adoption and success through Smartsheet, from their experience as both a solution builder and as a member of their organisation’s executive team.
Effectively manage teams with Resource Management - June 11 - REGISTER HERE
Pete Broglie, Associate Director of Program and Process Management, will share how they use Smartsheet and Resource Management to stay on track with timelines, budgets, and resources. He’ll highlight how the Advanced Reporting feature helps bring Time & Fees, Utilization, Expenses, and Budget data into Smartsheet—making it easier to automate reporting, visualize metrics, and support smarter decisions.
Looking to connect with local users? Check out our webpage to see our upcoming in-person schedule.
Torey Tirpack
Re: Combine Specific Characters from Multiple Cells
@Gillian C This is perfect! Exactly what I needed, thank you!
LindsayM