Salesforce Imports Apostrophes
This is a public service announcement... If you have an Index/Match that isn't working, and the source sheet is a data mesh or data shuttle from Salesforce, check the numeric field to make sure there isn't a leading apostrophe. The apostrophe will not appear until you click in the cell. You can rid of it with a helper…
Check Out My New Demo Web App: A Smartsheet Dashboard Visualizer!
Hello All, I'm excited to share a simple yet effective demo of my new web app showcasing Smartsheet's API's power. You can find it here: https://api.smartsheetdev.io/login. It's Free and secure! What's This App About? After successful OAuth2 authentication, you'll be directed to a Smartsheet Dashboard. It's a…
I recently received a promotion from Project Mgr. to Assistant Director for Systems integration for data and strategy. I can't celebrate without attributing Smartsheet for this achievement.
(Solution) Using ZIP to get Per Diem M&EI Rates with Python
I've been testing new things with the Smartsheet API via python. Somebody down the road might find value with this if they want to build their own expense report system. It works by checking a column called "ZIP Code", and then looking at the bottom of the sheet for the latest entry, then gets the row ID. Once it has the…
How to Search for Duplicate Ideas
This discussion was created from comments split from: FAQs and Guidelines for posting Product Feedback Ideas.
Background auto-refresh a sheet as frequently as every minute.
This might be my first real contribution to this community, but I think I have had a breakthrough with respect to background auto refreshing a sheet. I've seen the common solution of utilizing a workflow to trigger a daily update of a date column, but the challenge has always been that you are obviously limited in how…
Good morning from Spain. I'm systems engineer and work as IT manager (kind of CTO and CEO) at a consultory named IBERSYD. I'm working with Smartsheet since January 2021, and I'm fully in love with it. I spend most of my time working daily with Smartsheet, creating its architecture, sheets, workflows, dashboards, and so. I…
Hopefully this post will help someone looking for a solution for dealing with time in Smartsheet outside of Resource Management. (Bolded the summary for quick access) I've recently run into an issue with a project. We are maintaining a lot of our data in Smartsheet, but a recent project got brought up about wanting to…
New Early Adopter! - Kayla Crosby
Good Morning! Now that I have joined the Smartsheet Early Adopter program, I am very excited to connect with follow Early Adopters and talk formula's, dashboards, reports, and all other things Smartsheet. I am originally from the state of Connecticut up in the Northeast, but I now reside in Orlando, FL and work for Loews…
How to access Core App Path Self-Paced eLearning courses?
I'm a licensed user and preparing for the Core Product Certification Exam (which I have purchased). I prefer the "Core App Path Self-Paced eLearning" as a guided preparation (versus this) but only 1 "welcome" course is showing up on my end: After completing this course, I clicked "next course" and got this notification:…